diff options
| author | Christopher Baines <mail@cbaines.net> | 2019-12-05 17:19:04 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2019-12-12 20:07:22 +0000 |
| commit | 0e97c55c0cabd6c3d2254e7bb02aa03ecf3314ca (patch) | |
| tree | 67e8ef689a91a74eefd6001ba06bf07cf9f2f325 /sqitch/deploy/add_some_database_indexes.sql | |
| parent | 00bfa5336e98fd20b7547abd7899d2c4a2a169c7 (diff) | |
| download | data-service-0e97c55c0cabd6c3d2254e7bb02aa03ecf3314ca.tar data-service-0e97c55c0cabd6c3d2254e7bb02aa03ecf3314ca.tar.gz | |
Add some database indexes
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; |