Re: [GENERAL] Autovacuum Logging

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, Will Reese <wreese(at)rackspace(dot)com>
Subject: Re: [GENERAL] Autovacuum Logging
Date: 2006-04-29 01:26:53
Message-ID: 200604282126.53378.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-04-29 01:54:17 Re: [GENERAL] Autovacuum Logging
Previous Message Bruce Momjian 2006-04-28 23:06:15 Re: [GENERAL] Autovacuum Logging

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-04-29 01:54:17 Re: [GENERAL] Autovacuum Logging
Previous Message Bruce Momjian 2006-04-28 23:06:15 Re: [GENERAL] Autovacuum Logging