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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings