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@xxxxxxxxxxxxx
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
