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. +