From 64be52844e679d205d959ea06d50c44366c39097 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Mon, 23 May 2022 19:10:25 +0100 Subject: Partition the package_derivations_by_guix_revision_range table And create a proper git_branches table in the process. I'm hoping this will help with slow deletions from the package_derivations_by_guix_revision_range table in the case where there are lots of branches, since it'll separate the data for one branch from another. These migrations will remove the existing data, so rebuild-package-derivations-table will currently need manually running to regenerate it. --- sqitch/revert/git_branch_id.sql | 7 +++++++ .../partition_package_derivations_by_guix_revision_range.sql | 7 +++++++ 2 files changed, 14 insertions(+) create mode 100644 sqitch/revert/git_branch_id.sql create mode 100644 sqitch/revert/partition_package_derivations_by_guix_revision_range.sql (limited to 'sqitch/revert') diff --git a/sqitch/revert/git_branch_id.sql b/sqitch/revert/git_branch_id.sql new file mode 100644 index 0000000..d9a18da --- /dev/null +++ b/sqitch/revert/git_branch_id.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:git_branch_id from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/revert/partition_package_derivations_by_guix_revision_range.sql b/sqitch/revert/partition_package_derivations_by_guix_revision_range.sql new file mode 100644 index 0000000..f3a1436 --- /dev/null +++ b/sqitch/revert/partition_package_derivations_by_guix_revision_range.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:partition_package_derivations_by_guix_revision_range from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; -- cgit v1.2.3