maintenance_workers - GradedJestRisk/db-training GitHub Wiki

Maintenance workers

AUTOVACUUM

Background writer

To disable, set bgwriter_lru_maxpages to 0

Statistics

select * from pg_stat_bgwriter;

Reset stats

SELECT pg_stat_reset_shared('bgwriter');

Checkpointer

To disable, set checkpoint_timeout to 1d

⚠️ GitHub.com Fallback ⚠️