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

Re: Autovacuum Logging

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, Will Reese <wreese(at)rackspace(dot)com>
Subject: Re: Autovacuum Logging
Date: 2006-04-28 19:56:19
Message-ID: 200604281956.k3SJuJK07680@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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: Bruce MomjianDate: 2006-04-28 19:58:16
Subject: Re: Automatic free space map filling
Previous:From: Jim ButtafuocoDate: 2006-04-28 19:42:29
Subject: Re: Autovacuum Logging

pgsql-general by date

Next:From: Don WalkerDate: 2006-04-28 20:15:59
Subject: Re: Use of ISpell dictionaries with tsearch2 - what is the point?
Previous:From: Jessica M SalmonDate: 2006-04-28 19:47:59
Subject: file I/O in plpgsql

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