From 9c1b989d203e49ad99eb69514b3ff1981acd9e5a Mon Sep 17 00:00:00 2001 From: Canan Talayhan Date: Thu, 27 May 2021 22:59:13 +0300 Subject: Add index for package_metadata This index speeds up inserting new entries to the package_metadata table. Signed-off-by: Christopher Baines --- sqitch/deploy/package_metadata_location_id_index.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sqitch/deploy/package_metadata_location_id_index.sql (limited to 'sqitch/deploy') diff --git a/sqitch/deploy/package_metadata_location_id_index.sql b/sqitch/deploy/package_metadata_location_id_index.sql new file mode 100644 index 0000000..3fa2aed --- /dev/null +++ b/sqitch/deploy/package_metadata_location_id_index.sql @@ -0,0 +1,7 @@ +-- Deploy guix-data-service:package_metadata_location_id_index to pg + +BEGIN; + +CREATE INDEX package_metadata_location_id ON package_metadata (location_id); + +COMMIT; -- cgit v1.2.3