Skip to content

Commit f56940b

Browse files
DiegoTavarescarlosfelgarcia
authored andcommitted
Add new indexes to improve booking performance (AcademySoftwareFoundation#1304)
* Add new indexes to improve booking performance After the changes on the gpu PR AcademySoftwareFoundation#924 the performance of the booking query degraded up to 4 times the previous throughput. Creating some indexes for columns that changed names seems to have fixed the problem. Signed-off-by: Diego Tavares <[email protected]> * Update cuebot/src/main/resources/conf/ddl/postgres/migrations/V18_Add_New_Indexes Signed-off-by: Diego Tavares da Silva <[email protected]> * Update cuebot/src/main/resources/conf/ddl/postgres/migrations/V18_Add_New_Indexes Signed-off-by: Diego Tavares da Silva <[email protected]> * Update cuebot/src/main/resources/conf/ddl/postgres/migrations/V18_Add_New_Indexes Signed-off-by: Diego Tavares da Silva <[email protected]> --------- Signed-off-by: Diego Tavares <[email protected]> Signed-off-by: Diego Tavares da Silva <[email protected]>
1 parent 8262097 commit f56940b

File tree

1 file changed

+29
-0
lines changed

1 file changed

+29
-0
lines changed
Lines changed: 29 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,29 @@
1+
2+
--Performance issue, Created new index on column int_gpus_min
3+
4+
5+
CREATE INDEX IF NOT EXISTS i_layer_int_gpu_mem_min
6+
ON public.layer USING btree
7+
(int_gpus_min ASC NULLS LAST)
8+
TABLESPACE pg_default;
9+
10+
11+
CREATE INDEX IF NOT EXISTS i_layer_int_gpu_mem_min_1
12+
ON public.layer USING btree
13+
(int_gpu_min ASC NULLS LAST)
14+
TABLESPACE pg_default;
15+
16+
17+
create index concurrently i_layer_int_cores_max on layer(int_cores_max);
18+
19+
create index concurrently i_job_resource_int_priority on job_resource(int_priority);
20+
21+
create index concurrently i_job_int_min_cores on job(int_min_cores);
22+
23+
create index concurrently i_layer_limit_pk_layer on layer_limit(pk_layer);
24+
25+
create index concurrently i_folder_resource_int_cores on folder_resource(int_cores);
26+
27+
create index concurrently i_job_ts_updated on job(ts_updated);
28+
29+
create index concurrently i_layer_str_tags on layer(str_tags);

0 commit comments

Comments
 (0)