Re: Autovacuum on by default?

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.