Re: [GENERAL] Autovacuum Logging

I am thinking, what do we want to show by default about autovacuum in
the server logs. What if we output a line the first time autovacuum
runs successfully on server start?

---------------------------------------------------------------------------

Bruce Momjian wrote:
> 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. +