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;

1 files changed, 9 insertions, 0 deletions

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;