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