Re: [HACKERS] pg_autovacuum misinterpreting reltuples?

2004-05-05 Thread Matthew T. O'Connor
Jeff Boes wrote: We noticed that one of our high-volume insert tables was being vacuumed every time pg_autovacuum woke up. (I"m running it with the default threshold values, and a 900-second sleep cycle.) The table has a few million rows in it. With "debug = 2" on, here's what the pg_autovacuum

[HACKERS] pg_autovacuum misinterpreting reltuples?

2004-05-05 Thread Jeff Boes
We noticed that one of our high-volume insert tables was being vacuumed every time pg_autovacuum woke up. (I"m running it with the default threshold values, and a 900-second sleep cycle.) The table has a few million rows in it. With "debug = 2" on, here's what the pg_autovacuum log reports for