1 files changed, 20 insertions, 0 deletions
diff --git a/sqitch/deploy/change_autovacuum_config.sql b/sqitch/deploy/change_autovacuum_config.sql
new file mode 100644
index 0000000..09d2c12
--- /dev/null
+++ b/sqitch/deploy/change_autovacuum_config.sql
@@ -0,0 +1,20 @@
+-- Deploy guix-data-service:change_autovacuum_config to pg
+
+BEGIN;
+
+ALTER TABLE derivations SET (autovacuum_vacuum_scale_factor = 0.01);
+ALTER TABLE derivations SET (autovacuum_analyze_scale_factor = 0.01);
+
+ALTER TABLE derivation_inputs SET (autovacuum_vacuum_scale_factor = 0.01);
+ALTER TABLE derivation_inputs SET (autovacuum_analyze_scale_factor = 0.01);
+
+ALTER TABLE guix_revision_package_derivations SET (autovacuum_vacuum_scale_factor = 0.01);
+ALTER TABLE guix_revision_package_derivations SET (autovacuum_analyze_scale_factor = 0.01);
+
+ALTER TABLE derivation_sources SET (autovacuum_vacuum_scale_factor = 0.01);
+ALTER TABLE derivation_sources SET (autovacuum_analyze_scale_factor = 0.01);
+
+ALTER TABLE derivation_outputs SET (autovacuum_vacuum_scale_factor = 0.01);
+ALTER TABLE derivation_outputs SET (autovacuum_analyze_scale_factor = 0.01);
+
+COMMIT;