From 893d8eec6659610f18c00e9996afec81c96e1592 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Thu, 18 Nov 2021 00:18:31 +0000 Subject: Add an index on output_metadata This should speed up fetching builds. --- sqitch/pg/deploy/output_metadata_index.sql | 7 +++++++ sqitch/pg/revert/output_metadata_index.sql | 7 +++++++ sqitch/pg/verify/output_metadata_index.sql | 7 +++++++ 3 files changed, 21 insertions(+) create mode 100644 sqitch/pg/deploy/output_metadata_index.sql create mode 100644 sqitch/pg/revert/output_metadata_index.sql create mode 100644 sqitch/pg/verify/output_metadata_index.sql (limited to 'sqitch/pg') diff --git a/sqitch/pg/deploy/output_metadata_index.sql b/sqitch/pg/deploy/output_metadata_index.sql new file mode 100644 index 0000000..7edfc5e --- /dev/null +++ b/sqitch/pg/deploy/output_metadata_index.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:output_metadata_index to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/output_metadata_index.sql b/sqitch/pg/revert/output_metadata_index.sql new file mode 100644 index 0000000..15c2c00 --- /dev/null +++ b/sqitch/pg/revert/output_metadata_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:output_metadata_index from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/output_metadata_index.sql b/sqitch/pg/verify/output_metadata_index.sql new file mode 100644 index 0000000..e7a316d --- /dev/null +++ b/sqitch/pg/verify/output_metadata_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:output_metadata_index on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; -- cgit v1.2.3