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/ ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
