--Performance issue, Created new index on column int_gpus_min

-- DROP INDEX IF EXISTS public.i_layer_int_gpu_mem_min;

CREATE INDEX IF NOT EXISTS i_layer_int_gpu_mem_min

ON public.layer USING btree

(int_gpus_min ASC NULLS LAST)

TABLESPACE pg_default;

-- DROP INDEX IF EXISTS public.i_layer_int_gpu_mem_min_1;

CREATE INDEX IF NOT EXISTS i_layer_int_gpu_mem_min_1

ON public.layer USING btree

(int_gpu_min ASC NULLS LAST)

TABLESPACE pg_default;

-- Created Indexes on Jun-26-2023 to improve query performance

create index concurrently i_layer_int_cores_max on layer(int_cores_max);

create index concurrently i_job_resource_int_priority on job_resource(int_priority);

create index concurrently i_job_int_min_cores on job(int_min_cores);

create index concurrently i_layer_limit_pk_layer on layer_limit(pk_layer);

create index concurrently i_folder_resource_int_cores on folder_resource(int_cores);

create index concurrently i_job_ts_updated on job(ts_updated);

create index concurrently i_layer_str_tags on layer(str_tags);