Re: [GENERAL] Autovacuum Logging - Mailing list pgsql-hackers

From Robert Treat
Subject Re: [GENERAL] Autovacuum Logging
Date
Msg-id 200604282126.53378.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: [GENERAL] Autovacuum Logging  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [GENERAL] Autovacuum Logging  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Friday 28 April 2006 19:06, Bruce Momjian wrote:
> 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?
>

If Larry can do the work of getting details added into the stats views, I'm 
comfortable just setting all of the logging to debug1 and leaving it at that. 
I still could see the idea of having a guc for an autovacuum specific log 
control; I could see an admin who first enables autovacuum might want to log 
all its activity for some period of time; but the angle of "need to verify it 
is turned on" goes away with the stats info. 

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Autovacuum Logging
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Autovacuum Logging