Re: Autovacuum Logging

Robert Treat wrote:
> On Thursday 27 April 2006 11:59, Bruce Momjian wrote:
> > Well, one problem now is that everytime pg_autovacuum opens a database,
> > a message is placed in the logs:
> >
> > LOG: autovacuum: processing database "test"
> > LOG: autovacuum: processing database "test"
> > LOG: autovacuum: processing database "test"
> > LOG: autovacuum: processing database "test"
> >
> > This is certainly not desirable. I changed the message to DEBUG1 for
> > 8.2 with the attached patch.
>
> IMHO this is less optimal, since the default installation will provide no way
> for users to verify that autovacuum is running. Currently we can direct them
> to look in thier log output, this way we would have to tell them to crank up
> logging to DEBUG1 and then look, which will of course contain a whole lot of
> other chatter at that level.

Someone is working on it.

> The best solution I have seen so far is the idea of a GUC to control
> autovacuums chatter level. I hope we get that becuase the above will be a
> regression imho.

The purpose of the logs is not to show something _working_, but to
report significant events. Frankly, even with the GUC, to see it is
working you are still going to fill up the logs with activity.

What do people want to know? --- that autovacuum is running, or how
often. If it is the former, we can print something on server startup.

We don't even really log checkpoints, so logging every autovacuum seems
strange.

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

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