diff options
author | Christopher Baines <mail@cbaines.net> | 2020-07-04 08:59:29 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2020-07-04 08:59:29 +0100 |
commit | 5dc9ed65ff179e71b34235d0a96729577cab3bd7 (patch) | |
tree | ece1899edf6b4c1b27f18e83d910d23e48186f19 /sqitch/revert | |
parent | 4b1dc76f186439cbc2b2c8d8238814b242b68417 (diff) | |
download | data-service-5dc9ed65ff179e71b34235d0a96729577cab3bd7.tar data-service-5dc9ed65ff179e71b34235d0a96729577cab3bd7.tar.gz |
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;
Diffstat (limited to 'sqitch/revert')
-rw-r--r-- | sqitch/revert/derivation_output_details_sets_derivation_output_details_ids_index.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/revert/derivation_output_details_sets_derivation_output_details_ids_index.sql b/sqitch/revert/derivation_output_details_sets_derivation_output_details_ids_index.sql new file mode 100644 index 0000000..aef856b --- /dev/null +++ b/sqitch/revert/derivation_output_details_sets_derivation_output_details_ids_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:derivation_output_details_sets_derivation_output_details_ids_index from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; |