Re: Autovacuum on by default?

Matthew T. O'Connor wrote:
> 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"

Yes, this was done.

> and increasing the log level when autovacuum actually fires off a VACUUM
> or ANALYZE command.

This was not done because the logging control only for autovacuum was
going to be added. Right now, if you want to see the vacuum activity,
you end up seeing debug stuff too (very ugly).

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +