diff options
| author | Christopher Baines <mail@cbaines.net> | 2022-09-14 10:26:03 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2022-09-14 10:26:03 +0100 |
| commit | e3062abf33f9887656ce4bd99f34317694533d50 (patch) | |
| tree | d5743a43ae552c7a26aadec3c99a3b5df588088e /sqitch | |
| parent | 12af30c0391cf344ddf9bc30a3497d37ec51de82 (diff) | |
| download | data-service-e3062abf33f9887656ce4bd99f34317694533d50.tar data-service-e3062abf33f9887656ce4bd99f34317694533d50.tar.gz | |
Speed up finding the locales for a revision
Diffstat (limited to 'sqitch')
| -rw-r--r-- | sqitch/deploy/package_derivations_id_package_id_idx.sql | 7 | ||||
| -rw-r--r-- | sqitch/revert/package_derivations_id_package_id_idx.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/verify/package_derivations_id_package_id_idx.sql | 7 |
4 files changed, 22 insertions, 0 deletions
diff --git a/sqitch/deploy/package_derivations_id_package_id_idx.sql b/sqitch/deploy/package_derivations_id_package_id_idx.sql new file mode 100644 index 0000000..ff05c4b --- /dev/null +++ b/sqitch/deploy/package_derivations_id_package_id_idx.sql @@ -0,0 +1,7 @@ +-- Deploy guix-data-service:package_derivations_id_package_id_idx to pg + +BEGIN; + +CREATE INDEX package_derivations_id_package_id_idx ON package_derivations (id, package_id) WITH (fillfactor='100'); + +COMMIT; diff --git a/sqitch/revert/package_derivations_id_package_id_idx.sql b/sqitch/revert/package_derivations_id_package_id_idx.sql new file mode 100644 index 0000000..4378119 --- /dev/null +++ b/sqitch/revert/package_derivations_id_package_id_idx.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:package_derivations_id_package_id_idx from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 5b7408b..a33137b 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -88,3 +88,4 @@ partition_package_derivations_by_guix_revision_range 2022-05-23T18:20:37Z Chris package_range_index 2022-06-17T10:39:31Z Chris <chris@felis> # Add index on package_derivations_by_guix_revision_range.package_name fix_git_commits_duplicates 2022-06-17T10:39:50Z Chris <chris@felis> # Fix git_commits duplicates git_repositories_query_substitutes 2022-09-09T11:35:16Z Chris <chris@felis> # Add git_repositories.query_substitutes +package_derivations_id_package_id_idx 2022-09-14T09:24:30Z Chris <chris@felis> # Add index on package_derivations id and package_id diff --git a/sqitch/verify/package_derivations_id_package_id_idx.sql b/sqitch/verify/package_derivations_id_package_id_idx.sql new file mode 100644 index 0000000..cf5c246 --- /dev/null +++ b/sqitch/verify/package_derivations_id_package_id_idx.sql @@ -0,0 +1,7 @@ +-- Verify guix-data-service:package_derivations_id_package_id_idx on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |