Hi Matthew,
Yes, I do have one query that creates a temporary table and that query
runs reasonably often, so that's a good explanation for the catalog tables.
Your query works perfectly on 8.4 and the ratio of dead rows to live
rows is generally quite small so it looks like everything is work
Dave,
Does your application use temporary tables? This may explain high
autovacuum activity in the catalog tables.
With regards to your tables, I wrote this very script to give me an
indication of the amount of required activity on the user tables. I
deliberately keep this one simple and it doe
Dave,
Does your application use temporary tables? This may explain high
autovacuum activity in the catalog tables.
With regards to your tables, I wrote this very script to give me an
indication of the amount of required activity on the user tables. I
deliberately keep this one simple and it doe
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
