From: Tom Clegg Date: Tue, 4 Sep 2018 19:03:58 +0000 (-0400) Subject: 14008: Merge branch 'master' into 14008-containers-index X-Git-Tag: 1.3.0~123^2 X-Git-Url: https://git.arvados.org/arvados.git/commitdiff_plain/3e5ac41e4e38e6c8fa72883b803d85fcde53e25b 14008: Merge branch 'master' into 14008-containers-index Arvados-DCO-1.1-Signed-off-by: Tom Clegg --- 3e5ac41e4e38e6c8fa72883b803d85fcde53e25b diff --cc services/api/db/structure.sql index 37dcfc1071,f42dd8d7cf..32b77ed17a --- a/services/api/db/structure.sql +++ b/services/api/db/structure.sql @@@ -1927,13 -1913,13 +1927,20 @@@ CREATE INDEX index_containers_on_modifi CREATE INDEX index_containers_on_owner_uuid ON public.containers USING btree (owner_uuid); +-- +-- Name: index_containers_on_queued_state; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX index_containers_on_queued_state ON public.containers USING btree (state, ((priority > 0))); + + + -- + -- Name: index_containers_on_reuse_columns; Type: INDEX; Schema: public; Owner: - + -- + + CREATE INDEX index_containers_on_reuse_columns ON public.containers USING btree (md5(command), cwd, md5(environment), output_path, container_image, md5(mounts), secret_mounts_md5, md5(runtime_constraints)); + + -- -- Name: index_containers_on_secret_mounts_md5; Type: INDEX; Schema: public; Owner: - -- @@@ -3144,9 -3130,7 +3151,11 @@@ INSERT INTO schema_migrations (version INSERT INTO schema_migrations (version) VALUES ('20180820130357'); +INSERT INTO schema_migrations (version) VALUES ('20180820132617'); + INSERT INTO schema_migrations (version) VALUES ('20180820135808'); + INSERT INTO schema_migrations (version) VALUES ('20180824152014'); + +INSERT INTO schema_migrations (version) VALUES ('20180824155207'); +