diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-05-11 09:39:47 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-05-11 09:39:47 +0100 |
| commit | ec8c7683d3dd8ceb6b8cb360295494671a0ac733 (patch) | |
| tree | 82cceaba355cfe06301bbbdca4451216558fc4c3 /sqitch/pg | |
| parent | 237ba68a52e7b532b73d5d228d44155ce72d5d45 (diff) | |
| download | build-coordinator-ec8c7683d3dd8ceb6b8cb360295494671a0ac733.tar build-coordinator-ec8c7683d3dd8ceb6b8cb360295494671a0ac733.tar.gz | |
Add some more indexes to speed up derivation ordered allocation
Diffstat (limited to 'sqitch/pg')
3 files changed, 21 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/more_indexes_on_builds_and_derivation_inputs.sql b/sqitch/pg/deploy/more_indexes_on_builds_and_derivation_inputs.sql new file mode 100644 index 0000000..7d248ea --- /dev/null +++ b/sqitch/pg/deploy/more_indexes_on_builds_and_derivation_inputs.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:more_indexes_on_builds_and_derivation_inputs to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/more_indexes_on_builds_and_derivation_inputs.sql b/sqitch/pg/revert/more_indexes_on_builds_and_derivation_inputs.sql new file mode 100644 index 0000000..c6a3f47 --- /dev/null +++ b/sqitch/pg/revert/more_indexes_on_builds_and_derivation_inputs.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:more_indexes_on_builds_and_derivation_inputs from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/more_indexes_on_builds_and_derivation_inputs.sql b/sqitch/pg/verify/more_indexes_on_builds_and_derivation_inputs.sql new file mode 100644 index 0000000..aee817e --- /dev/null +++ b/sqitch/pg/verify/more_indexes_on_builds_and_derivation_inputs.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:more_indexes_on_builds_and_derivation_inputs on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |