diff options
Diffstat (limited to 'sqitch/deploy/add_some_database_indexes.sql')
-rw-r--r-- | sqitch/deploy/add_some_database_indexes.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sqitch/deploy/add_some_database_indexes.sql b/sqitch/deploy/add_some_database_indexes.sql new file mode 100644 index 0000000..1af1d3f --- /dev/null +++ b/sqitch/deploy/add_some_database_indexes.sql @@ -0,0 +1,10 @@ +-- Deploy guix-data-service:add_some_database_indexes to pg + +BEGIN; + +CREATE INDEX ON derivation_outputs (derivation_id); +CREATE INDEX ON derivation_outputs (derivation_output_details_id); +CREATE INDEX ON nars (store_path); +CREATE INDEX ON package_derivations (package_id); + +COMMIT; |