diff options
Diffstat (limited to 'sqitch/deploy')
4 files changed, 81 insertions, 0 deletions
diff --git a/sqitch/deploy/change_package_derivations_by_guix_revision_range_target.sql b/sqitch/deploy/change_package_derivations_by_guix_revision_range_target.sql new file mode 100644 index 0000000..7ba90c7 --- /dev/null +++ b/sqitch/deploy/change_package_derivations_by_guix_revision_range_target.sql @@ -0,0 +1,15 @@ +-- Deploy guix-data-service:change_package_derivations_by_guix_revision_range_target to pg + +BEGIN; + +UPDATE package_derivations_by_guix_revision_range SET target = '' WHERE system = target; + +DELETE FROM package_derivations_by_guix_revision_range WHERE target IN ( + 'aarch64-linux', + 'armhf-linux', + 'i686-linux', + 'mips64el-linux', + 'x86_64-linux' +); + +COMMIT; diff --git a/sqitch/deploy/change_package_derivations_target.sql b/sqitch/deploy/change_package_derivations_target.sql new file mode 100644 index 0000000..9a9f3c3 --- /dev/null +++ b/sqitch/deploy/change_package_derivations_target.sql @@ -0,0 +1,7 @@ +-- Deploy guix-data-service:change_package_derivations_target to pg + +BEGIN; + +UPDATE package_derivations SET target = '' WHERE system = target; + +COMMIT; diff --git a/sqitch/deploy/increase_fillfactor_for_some_indexes.sql b/sqitch/deploy/increase_fillfactor_for_some_indexes.sql new file mode 100644 index 0000000..93f8209 --- /dev/null +++ b/sqitch/deploy/increase_fillfactor_for_some_indexes.sql @@ -0,0 +1,29 @@ +-- Deploy guix-data-service:increase_fillfactor_for_some_indexes to pg + +BEGIN; + +ALTER INDEX derivation_inputs_pkey SET (fillfactor = 100); +ALTER INDEX derivation_inputs_derivation_output_id_idx SET (fillfactor = 100); +ALTER INDEX guix_revision_package_derivations_pkey SET (fillfactor = 100); +ALTER INDEX derivations_pkey SET (fillfactor = 100); +ALTER INDEX file_name_unique SET (fillfactor = 100); +ALTER INDEX id_unique SET (fillfactor = 100); +ALTER INDEX derivations_hash SET (fillfactor = 100); +ALTER INDEX package_derivations_pkey SET (fillfactor = 100); +ALTER INDEX package_derivations_id_key SET (fillfactor = 100); +ALTER INDEX package_derivations_derivation_id SET (fillfactor = 100); +ALTER INDEX package_derivations_package_id_idx SET (fillfactor = 100); + +REINDEX INDEX derivation_inputs_pkey; +REINDEX INDEX derivation_inputs_derivation_output_id_idx; +REINDEX INDEX guix_revision_package_derivations_pkey; +REINDEX INDEX derivations_pkey; +REINDEX INDEX file_name_unique; +REINDEX INDEX id_unique; +REINDEX INDEX derivations_hash; +REINDEX INDEX package_derivations_pkey; +REINDEX INDEX package_derivations_id_key; +REINDEX INDEX package_derivations_derivation_id; +REINDEX INDEX package_derivations_package_id_idx; + +COMMIT; diff --git a/sqitch/deploy/remove_old_cross_derivations.sql b/sqitch/deploy/remove_old_cross_derivations.sql new file mode 100644 index 0000000..b035673 --- /dev/null +++ b/sqitch/deploy/remove_old_cross_derivations.sql @@ -0,0 +1,30 @@ +-- Deploy guix-data-service:remove_old_cross_derivations to pg + +BEGIN; + +DELETE FROM guix_revision_package_derivations WHERE package_derivation_id IN ( + SELECT id + FROM package_derivations + WHERE target IN ( + 'aarch64-linux', + 'armhf-linux', + 'i686-linux', + 'mips64el-linux', + 'x86_64-linux' + ) +); + +-- Checking this constraint is expensive, so drop it, then re-create it +ALTER TABLE guix_revision_package_derivations DROP CONSTRAINT guix_revision_package_derivations_package_derivation_id_fkey; + +DELETE FROM package_derivations WHERE target IN ( + 'aarch64-linux', + 'armhf-linux', + 'i686-linux', + 'mips64el-linux', + 'x86_64-linux' +); + +ALTER TABLE guix_revision_package_derivations ADD CONSTRAINT "guix_revision_package_derivations_package_derivation_id_fkey" FOREIGN KEY (package_derivation_id) REFERENCES package_derivations(id); + +COMMIT; |