From: | Will Reese <wreese(at)rackspace(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Autovacuum Logging |
Date: | 2006-04-27 04:09:53 |
Message-ID: | 0E68808E-4E7E-45AF-8EC5-543C79A3141A@rackspace.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | chris smith | 2006-04-27 04:16:15 | Re: PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34 PROBLEM!! PLEASE HELP |
Previous Message | Michael Artz | 2006-04-27 03:54:23 | Disk Failure Scenarios |
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2006-04-27 04:52:43 | Re: [HACKERS] pg_dump |
Previous Message | Will Reese | 2006-04-27 03:47:26 | Autovacuum Logging |