diff options
author | Christopher Baines <mail@cbaines.net> | 2020-04-28 18:49:38 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2020-04-28 18:49:38 +0100 |
commit | b101326b4ebdd1f1a090d4ba14da88747693d949 (patch) | |
tree | c9dbb6ae01675dab74f7e89b87d4703f2ccdbe3d /sqitch/pg | |
parent | bc3bbb6eadeeaf38243e9edc8272021a8f4f1517 (diff) | |
download | build-coordinator-b101326b4ebdd1f1a090d4ba14da88747693d949.tar build-coordinator-b101326b4ebdd1f1a090d4ba14da88747693d949.tar.gz |
Create an index on derivation_outputs.output
This is important to speed up looking for derivations that provide an output,
that's used in the allocation process.
Diffstat (limited to 'sqitch/pg')
-rw-r--r-- | sqitch/pg/deploy/derivation_outputs_output_index.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/revert/derivation_outputs_output_index.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/verify/derivation_outputs_output_index.sql | 7 |
3 files changed, 21 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/derivation_outputs_output_index.sql b/sqitch/pg/deploy/derivation_outputs_output_index.sql new file mode 100644 index 0000000..e48ad83 --- /dev/null +++ b/sqitch/pg/deploy/derivation_outputs_output_index.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:derivation_outputs_output_index to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/derivation_outputs_output_index.sql b/sqitch/pg/revert/derivation_outputs_output_index.sql new file mode 100644 index 0000000..21309f9 --- /dev/null +++ b/sqitch/pg/revert/derivation_outputs_output_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:derivation_outputs_output_index from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/derivation_outputs_output_index.sql b/sqitch/pg/verify/derivation_outputs_output_index.sql new file mode 100644 index 0000000..05de261 --- /dev/null +++ b/sqitch/pg/verify/derivation_outputs_output_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:derivation_outputs_output_index on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |