Re: Autovacuum Logging - Mailing list pgsql-general

From Will Reese
Subject Re: Autovacuum Logging
Date
Msg-id 0E68808E-4E7E-45AF-8EC5-543C79A3141A@rackspace.com
Whole thread Raw
In response to Autovacuum Logging  (Will Reese <wreese@rackspace.com>)
List pgsql-general
I found where I saw that EnterpriseDB has enabled autovacuum logging.
Look at item number one under the section entitled "Changes in
2006-03-31 update:"

http://www.enterprisedb.com/readme_dbserver.do


Will Reese -- http://blog.rezra.com

On Apr 26, 2006, at 10:47 PM, Will Reese wrote:

> Is there a reason many of the most useful autovacuum.c elog
> statements are set to DEBUG2?  It seems to me that these should be
> set to LOG.
>
> I used autovacuum when it was a contrib module, and it failed after
> a month.  To prevent major performance problems I went back to the
> daily vacuum.  I was looking forward to using autovacuum in 8.1
> since it is more resilient and configurable now, but when I noticed
> it would not log it's activities I almost decided against it.
> After looking at the source code it seems that all the necessary
> logging is built in, it's just not set to the appropriate log
> level.  I'm sure I'm not the only person interested in this, and I
> saw somewhere (I can't find it again) that EnterpriseDB has enabled
> autovacuum logging.  I don't think it's too verbose to change these
> to the normal log level, but if so could it be a postgresql.conf
> option to enable/disable autovacuum logging?  It sure would be nice
> to be able to verify that tables are being vacuumed properly
> without having to set the log level to DEBUG2.
>
> Will Reese -- http://blog.rezra.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend


pgsql-general by date:

Previous
From: "Michael Artz"
Date:
Subject: Disk Failure Scenarios
Next
From: "chris smith"
Date:
Subject: Re: PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34 PROBLEM!! PLEASE HELP