Re: More logging for autovacuum - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: More logging for autovacuum
Date
Msg-id 200708071701.39239.dfontaine@hi-media.com
Whole thread Raw
In response to Re: More logging for autovacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: More logging for autovacuum  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
Le mardi 07 août 2007, Tom Lane a écrit :
> Gregory Stark <stark@enterprisedb.com> writes:
> > log_autovacuum_jobs - output every time a vacuum or analyze *starts*
[...]
> > 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.

If I understand correctly what is proposed, the log_autovacuum_jobs option
would allow the user to choose whether or not he wants its log cluttered by
autovacuum. I know I'd choose to clutter them, and would prefer not having to
choose a DEBUG loglevel to have autovacuum logs...

Regards,
--
dim

pgsql-hackers by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: More logging for autovacuum
Next
From: Gregory Stark
Date:
Subject: Re: More logging for autovacuum