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/deploy/derivation_outputs_output_index.sql | |
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/deploy/derivation_outputs_output_index.sql')
-rw-r--r-- | sqitch/pg/deploy/derivation_outputs_output_index.sql | 7 |
1 files changed, 7 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; |