Re: More logging for autovacuum

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "PostgreSQL-development Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: More logging for autovacuum
Date: 2007-08-07 15:23:50
Message-ID: 877io7id15.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Gregory Stark <stark(at)enterprisedb(dot)com> writes:
>> I would also suggest raising the level of the DEBUG2 message indicating why
>> tables were chosen or not. At least to DEBUG1 if not to INFO.
>
> It's not acceptable for autovacuum to be cluttering the log by default.

Well log_min_messages is NOTICE by default so neither INFO nor DEBUG1 would
actually clutter the logs by default, but it sounds like you would prefer at
most DEBUG1?

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas ADI SD 2007-08-07 15:26:15 Re: HOT pgbench results
Previous Message Dimitri Fontaine 2007-08-07 15:01:36 Re: More logging for autovacuum