From: Tom Clegg <tclegg@veritasgenetics.com>
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?hp=-c

14008: Merge branch 'master' into 14008-containers-index

Arvados-DCO-1.1-Signed-off-by: Tom Clegg <tclegg@veritasgenetics.com>
---

3e5ac41e4e38e6c8fa72883b803d85fcde53e25b
diff --combined services/api/db/structure.sql
index 37dcfc1071,f42dd8d7cf..32b77ed17a
--- a/services/api/db/structure.sql
+++ b/services/api/db/structure.sql
@@@ -1899,20 -1899,6 +1899,20 @@@ CREATE UNIQUE INDEX index_container_req
  CREATE INDEX index_containers_on_auth_uuid ON public.containers USING btree (auth_uuid);
  
  
 +--
 +-- Name: index_containers_on_locked_by_uuid_and_priority; Type: INDEX; Schema: public; Owner: -
 +--
 +
 +CREATE INDEX index_containers_on_locked_by_uuid_and_priority ON public.containers USING btree (locked_by_uuid, priority);
 +
 +
 +--
 +-- Name: index_containers_on_locked_by_uuid_and_uuid; Type: INDEX; Schema: public; Owner: -
 +--
 +
 +CREATE INDEX index_containers_on_locked_by_uuid_and_uuid ON public.containers USING btree (locked_by_uuid, uuid);
 +
 +
  --
  -- Name: index_containers_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
  --
@@@ -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');
 +