May 2018
Intermediate to advanced
576 pages
30h 25m
English
The first thing to do is make sure that autovacuum is switched on, which is the default. Check that you have the following parameters enabled in your postgresql.conf file:
autovacuum = on track_counts = on
PostgreSQL controls autovacuum with more than 40 individually tunable parameters. That provides a wide range of options, though it can be a little daunting.
The following are the relevant parameters that can be set in postgresql.conf to tune the VACUUM command:
vacuum_cost_page_dirtyvacuum_cost_page_hitvacuum_cost_page_missvacuum_cost_delayvacuum_cost_limitvacuum_freeze_min_agevacuum_freeze_table_agevacuum_multixact_freeze_min_agevacuum_multixact_freeze_table_age
There are also parameters that apply specifically to the