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 | |
| 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')
| -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 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/sqlite/deploy/output_metadata_index.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqlite/revert/output_metadata_index.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqlite/verify/output_metadata_index.sql | 7 |
7 files changed, 43 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; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 6a2ddcd..7c0c20e 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -36,3 +36,4 @@ create_outputs 2021-05-21T13:37:49Z Christopher Baines <mail@cbaines.net> # Crea create_systems 2021-05-21T17:22:52Z Christopher Baines <mail@cbaines.net> # Create the systems table create_unprocessed_builds_with_derived_priorities 2021-10-22T14:52:18Z Christopher Baines <mail@cbaines.net> # Create unprocessed_builds_with_derived_priorities add_agents_active 2021-11-12T14:00:52Z Christopher Baines <mail@cbaines.net> # Add agents.active +output_metadata_index 2021-11-18T00:18:12Z Christopher Baines <mail@cbaines.net> # Add index on output_metadata diff --git a/sqitch/sqlite/deploy/output_metadata_index.sql b/sqitch/sqlite/deploy/output_metadata_index.sql new file mode 100644 index 0000000..b67f957 --- /dev/null +++ b/sqitch/sqlite/deploy/output_metadata_index.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:output_metadata_index to sqlite + +BEGIN; + +CREATE INDEX output_metadata_build_id_idx ON output_metadata (build_id); + +COMMIT; diff --git a/sqitch/sqlite/revert/output_metadata_index.sql b/sqitch/sqlite/revert/output_metadata_index.sql new file mode 100644 index 0000000..79116bc --- /dev/null +++ b/sqitch/sqlite/revert/output_metadata_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:output_metadata_index from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/output_metadata_index.sql b/sqitch/sqlite/verify/output_metadata_index.sql new file mode 100644 index 0000000..cc8c81a --- /dev/null +++ b/sqitch/sqlite/verify/output_metadata_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:output_metadata_index on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |