aboutsummaryrefslogtreecommitdiff
path: root/sqitch/deploy/add_some_database_indexes.sql
blob: 1af1d3fe9295d6d9925789f3f62d4b4b94ae84e8 (plain)
1
2
3
4
5
6
7
8
9
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;