x27;,'autovacuum_vacuum_scale_factor','autovacuum_analyze_scale_factor','autovacuum_analyze_threshold');
If your tables are particularly large then the number of dead rows may
not qualify autovacuum_vacuum_scale_factor. What is the ratio between
live and dead rows?
On
Hi there,
I'm wondering if I'm seeing the appropriate amount of vacuuming in my
8.4 database.
I have a database with about twenty tables ranging from small, mostly
static, tables to tables with tens or hundreds of thousands of rows and
a fair number of inserts and updates (but very few delet