Re: [GENERAL] Autovacuum Logging

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