From b101326b4ebdd1f1a090d4ba14da88747693d949 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Tue, 28 Apr 2020 18:49:38 +0100 Subject: 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. --- sqitch/pg/deploy/derivation_outputs_output_index.sql | 7 +++++++ sqitch/pg/revert/derivation_outputs_output_index.sql | 7 +++++++ sqitch/pg/verify/derivation_outputs_output_index.sql | 7 +++++++ sqitch/sqitch.plan | 1 + sqitch/sqlite/deploy/derivation_outputs_output_index.sql | 7 +++++++ sqitch/sqlite/revert/derivation_outputs_output_index.sql | 7 +++++++ sqitch/sqlite/verify/derivation_outputs_output_index.sql | 7 +++++++ 7 files changed, 43 insertions(+) create mode 100644 sqitch/pg/deploy/derivation_outputs_output_index.sql create mode 100644 sqitch/pg/revert/derivation_outputs_output_index.sql create mode 100644 sqitch/pg/verify/derivation_outputs_output_index.sql create mode 100644 sqitch/sqlite/deploy/derivation_outputs_output_index.sql create mode 100644 sqitch/sqlite/revert/derivation_outputs_output_index.sql create mode 100644 sqitch/sqlite/verify/derivation_outputs_output_index.sql 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; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 1e4414f..6f49810 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -9,3 +9,4 @@ build_allocation_tables 2020-04-10T19:26:36Z Christopher Baines # Create table for storing build results setup_failures 2020-04-13T13:05:29Z Christopher Baines # Create table for storing setup_failures output_metadata 2020-04-23T14:26:15Z Christopher Baines # Create table for storing output metadata +derivation_outputs_output_index 2020-04-28T17:49:19Z Christopher Baines # Add an index on derivation_outputs.output diff --git a/sqitch/sqlite/deploy/derivation_outputs_output_index.sql b/sqitch/sqlite/deploy/derivation_outputs_output_index.sql new file mode 100644 index 0000000..58e3b1f --- /dev/null +++ b/sqitch/sqlite/deploy/derivation_outputs_output_index.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:derivation_outputs_output_index to sqlite + +BEGIN; + +CREATE INDEX derivation_outputs_output_idx ON derivation_outputs (output); + +COMMIT; diff --git a/sqitch/sqlite/revert/derivation_outputs_output_index.sql b/sqitch/sqlite/revert/derivation_outputs_output_index.sql new file mode 100644 index 0000000..cd33104 --- /dev/null +++ b/sqitch/sqlite/revert/derivation_outputs_output_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:derivation_outputs_output_index from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/derivation_outputs_output_index.sql b/sqitch/sqlite/verify/derivation_outputs_output_index.sql new file mode 100644 index 0000000..a693a27 --- /dev/null +++ b/sqitch/sqlite/verify/derivation_outputs_output_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:derivation_outputs_output_index on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; -- cgit v1.2.3