blob: 09d2c128967b8dbf90509db025e7cc11a84f7c9c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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;
|