Re: We need to log aborted autovacuums
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>, Tom Lane <tgl@sss.pgh.pa.us>, Simon Riggs <simon@2ndquadrant.com>, Greg Smith <greg@2ndquadrant.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-02-04T12:08:58Z
Lists: pgsql-hackers
On Fri, Feb 4, 2011 at 12:59 AM, Josh Berkus <josh@agliodbs.com> wrote: > Robert, > >> Seeing as how there seem to be neither objections nor endorsements, >> I'm inclined to commit what I proposed more or less as-is. There >> remains the issue of what do about the log spam. Josh Berkus >> suggested logging it when log_autovacuum_min_duration != -1, which >> seems like a bit of an abuse of that setting, but it's certainly not >> worth adding another setting for, and the alternative of logging it >> at, say, DEBUG2 seems unappealing because you'll then have to turn on >> logging for a lot of unrelated crap to get this information. So on >> balance I think that proposal is perhaps the least of evils. > > Wait, which proposal is? I meant to say that I think the "least evil" proposal is to log at LOG when log_autovacuum_min_duration != -1. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company