Re: Autovacuum Logging - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Autovacuum Logging
Date
Msg-id 200604281956.k3SJuJK07680@candle.pha.pa.us
Whole thread Raw
In response to Re: Autovacuum Logging  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
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. +

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: How to define + operator for strings
Next
From: "Don Walker"
Date:
Subject: Re: Use of ISpell dictionaries with tsearch2 - what is the point?