aboutsummaryrefslogtreecommitdiff
path: root/sqitch/deploy
diff options
context:
space:
mode:
Diffstat (limited to 'sqitch/deploy')
-rw-r--r--sqitch/deploy/change_package_derivations_by_guix_revision_range_target.sql15
-rw-r--r--sqitch/deploy/change_package_derivations_target.sql7
-rw-r--r--sqitch/deploy/increase_fillfactor_for_some_indexes.sql29
-rw-r--r--sqitch/deploy/remove_old_cross_derivations.sql30
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;