Re: Autovacuum on by default?

Bruce Momjian wrote:
> It is by default for unusual activity. It can be for normal activity
> using the proper GUC settings, but we don't have a way to control
> that just for autovacuum yet, and given what we have in 8.2, I don't
> see a need to add more until users say they need more.

Right, the server log should tend to being empty if there is nothing
unusual happening. I recall that someone once complained about every
checkpoint run making an entry; and every autovacuum run making one
would be about the same. Certainly, there is room for more fine-tuning
here, but the all-important question "Has autovacuum ever run
(recently)" can now be easily answered in 8.2, so we're good.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/