From 5dc9ed65ff179e71b34235d0a96729577cab3bd7 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Sat, 4 Jul 2020 08:59:29 +0100 Subject: Add a index to derivation_output_details_sets This helps with queries like: SELECT * FROM derivation_output_details_sets WHERE ARRAY[5563227] <@ derivation_output_details_ids; --- ...n_output_details_sets_derivation_output_details_ids_index.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sqitch/deploy/derivation_output_details_sets_derivation_output_details_ids_index.sql (limited to 'sqitch/deploy') diff --git a/sqitch/deploy/derivation_output_details_sets_derivation_output_details_ids_index.sql b/sqitch/deploy/derivation_output_details_sets_derivation_output_details_ids_index.sql new file mode 100644 index 0000000..c755127 --- /dev/null +++ b/sqitch/deploy/derivation_output_details_sets_derivation_output_details_ids_index.sql @@ -0,0 +1,9 @@ +-- Deploy guix-data-service:derivation_output_details_sets_derivation_output_details_ids_index to pg + +BEGIN; + +CREATE INDEX derivation_output_details_sets_gin_idx + ON derivation_output_details_sets + USING GIN (derivation_output_details_ids); + +COMMIT; -- cgit v1.2.3