Logging pg_autovacuum - Mailing list pgsql-hackers

From Bruce Momjian
Subject Logging pg_autovacuum
Date
Msg-id 200604271737.k3RHbtv00532@candle.pha.pa.us
Whole thread Raw
Responses Re: Logging pg_autovacuum
Re: Logging pg_autovacuum
List pgsql-hackers
Tom Lane wrote:
> momjian@postgresql.org (Bruce Momjian) writes:
> > Change log message about vacuuming database name from LOG to DEBUG1.
> > Prevents duplicate meaningless log messsages.
> 
> Could we have some discussion about this sort of thing, rather than
> unilateral actions?
> 
> Those messages were at LOG level because otherwise it's difficult to be
> sure from the log that autovac is running at all.

OK, so what do we want to do?  Clearly outputing something everytime
pg_autovacuum touches a database isn't ideal.  By default, the server
logs should show significant events, which this is not.

Do we want something output only the first time autovacuum runs?

--  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-hackers by date:

Previous
From: Taral
Date:
Subject: Re: ANSI-strict pointer aliasing rules
Next
From: Martijn van Oosterhout
Date:
Subject: Re: ANSI-strict pointer aliasing rules