Re: [GENERAL] Expected frequency of auto_vacuum activity

2010-11-15 Thread Dave Jennings
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

[GENERAL] Expected frequency of auto_vacuum activity

2010-11-15 Thread Dave Jennings
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