diff options
| author | Christopher Baines <mail@cbaines.net> | 2021-11-18 00:18:31 +0000 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2021-11-18 00:18:38 +0000 |
| commit | 893d8eec6659610f18c00e9996afec81c96e1592 (patch) | |
| tree | e62a0315ba35f4a21bc9ead4853392d51e382230 /sqitch/pg | |
| parent | 1f4656b72d860c198cc6af7e8e56279e401e1e66 (diff) | |
| download | build-coordinator-893d8eec6659610f18c00e9996afec81c96e1592.tar build-coordinator-893d8eec6659610f18c00e9996afec81c96e1592.tar.gz | |
Add an index on output_metadata
This should speed up fetching builds.
Diffstat (limited to 'sqitch/pg')
| -rw-r--r-- | sqitch/pg/deploy/output_metadata_index.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/revert/output_metadata_index.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/verify/output_metadata_index.sql | 7 |
3 files changed, 21 insertions, 0 deletions
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; |