aboutsummaryrefslogtreecommitdiff
path: root/sqitch/pg
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-04-29 18:02:06 +0100
committerChristopher Baines <mail@cbaines.net>2020-04-29 18:02:06 +0100
commit5f01bb9edaac3649998c90fe400f4cd98c668d95 (patch)
tree2cf9d08c8389b3060cea95cd34b88c2f52accfa9 /sqitch/pg
parent774971e06ce6b7ac3fe746683aad16463bf1b3ee (diff)
downloadbuild-coordinator-5f01bb9edaac3649998c90fe400f4cd98c668d95.tar
build-coordinator-5f01bb9edaac3649998c90fe400f4cd98c668d95.tar.gz
Add a couple of indexes that should speed up allocating builds
Diffstat (limited to 'sqitch/pg')
-rw-r--r--sqitch/pg/deploy/allocator_related_indexes.sql7
-rw-r--r--sqitch/pg/revert/allocator_related_indexes.sql7
-rw-r--r--sqitch/pg/verify/allocator_related_indexes.sql7
3 files changed, 21 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/allocator_related_indexes.sql b/sqitch/pg/deploy/allocator_related_indexes.sql
new file mode 100644
index 0000000..6e4f902
--- /dev/null
+++ b/sqitch/pg/deploy/allocator_related_indexes.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-build-coordinator:allocator_related_indexes to pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/revert/allocator_related_indexes.sql b/sqitch/pg/revert/allocator_related_indexes.sql
new file mode 100644
index 0000000..fead415
--- /dev/null
+++ b/sqitch/pg/revert/allocator_related_indexes.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:allocator_related_indexes from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/verify/allocator_related_indexes.sql b/sqitch/pg/verify/allocator_related_indexes.sql
new file mode 100644
index 0000000..d75e9e0
--- /dev/null
+++ b/sqitch/pg/verify/allocator_related_indexes.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:allocator_related_indexes on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;