Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Autovacuum Logging

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, Will Reese <wreese(at)rackspace(dot)com>
Subject: Re: [GENERAL] Autovacuum Logging
Date: 2006-04-28 23:06:15
Message-ID: 200604282306.k3SN6F619219@candle.pha.pa.us (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-generalpgsql-hackers
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. +

In response to

Responses

pgsql-hackers by date

Next:From: Robert TreatDate: 2006-04-29 01:26:53
Subject: Re: [GENERAL] Autovacuum Logging
Previous:From: Bruce MomjianDate: 2006-04-28 22:54:59
Subject: Re: Solaris ASM problem

pgsql-general by date

Next:From: Robert TreatDate: 2006-04-29 01:26:53
Subject: Re: [GENERAL] Autovacuum Logging
Previous:From: Dany De BontridderDate: 2006-04-28 22:00:15
Subject: dump Functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group