Skip site navigation (1) Skip section navigation (2)

Re: Autovacuum Logging

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Will Reese <wreese(at)rackspace(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Autovacuum Logging
Date: 2006-04-27 15:49:40
Message-ID: 4450E814.3000508@zeut.net (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Right, I think there has been discussion about this and general 
agreement that the current autovacuum logging options are less than 
ideal to put it mildly.  Unfortunately, I don't think there has been any 
action by anyone to do something about it.  I hope to work on this at 
some point, but coding time for PG scarce resource in my life, so no 
promises.

Matt



Will Reese wrote:
> 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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2006-04-27 15:57:10
Subject: pgsql: Change log message about vacuuming database name from LOG to
Previous:From: Jonah H. HarrisDate: 2006-04-27 15:43:29
Subject: Re: Summer of Code idea

pgsql-general by date

Next:From: Bruce MomjianDate: 2006-04-27 15:59:51
Subject: Re: Autovacuum Logging
Previous:From: G. Ralph Kuntz, MDDate: 2006-04-27 15:36:33
Subject: Repost: Problem with pg_ctl register -w

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group