From: | Will Reese <wreese(at)rackspace(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Autovacuum Logging |
Date: | 2006-04-27 05:58:48 |
Message-ID: | BC9A32D2-F354-4001-BC77-F38DC31DA4E1@rackspace.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
I found this short discussion between Tom and Bruce, but that's about
it for autovacuum logging.
http://archives.postgresql.org/pgsql-general/2006-04/msg00489.php
It just seems like the "processing database" log statement should be
set to a lower level, since it just logs every time autovacuum runs.
And the "vacuum table" log statement should be set to LOG since it
will only log when it actually vacuums a table, which is very useful
and important information. If Bruce's solution is implemented in 8.2
that would be nice, but raising the log level from DEBUG2 to LOG
would be a nice patch for 8.1.4 in the meantime. :)
Will Reese -- http://blog.rezra.com
On Apr 27, 2006, at 12:20 AM, Jim C. Nasby wrote:
> I believe 8.2 will have improved autovac logging. Take a look in the
> -hackers archives for more info.
>
> On Wed, Apr 26, 2006 at 10:47:26PM -0500, 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
>>
>
> --
> Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
> Pervasive Software http://pervasive.com work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Velevitch | 2006-04-27 06:52:33 | Mailing list setup issue |
Previous Message | Martijn van Oosterhout | 2006-04-27 05:49:08 | Re: [HACKERS] pg_dump |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-04-27 07:24:14 | Re: ANSI-strict pointer aliasing rules |
Previous Message | Martijn van Oosterhout | 2006-04-27 05:49:08 | Re: [HACKERS] pg_dump |