Bruce Momjian wrote:
Matthew T. O'Connor wrote:
Would be fine by me, but I'm curious to see what the community has to say. A few comments:

Autovacuum can cause unpredictable performance issues, that is if it vacuums in the middle of a busy day and people don't want that, of course they turn it off easy enough, but they might be surprised.

I haven't played with CVS HEAD much, but I think the logging issue has been addressed no? That is my single biggest gripe with the 8.1 autovacuum is that it's very hard to see if it's actually done anything without having to turn up the logging significantly.

This has not been addressed, except that pg_stat_activity now shows
autovacuum.  Someone was going to work on per-module log output, but it
wasn't completed for 8.2.   Does pg_stat_activity now show the table
being vacuumed?

Hmm... I though it had, not the full blown per-module log output stuff, but just a simple reorgainzing of the log levels for autovacuum messages. That is lowering the level for:
LOG:  autovacuum: processing database "foo"
and increasing the log level when autovacuum actually fires off a VACUUM or ANALYZE command.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to