| From: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gregory Stark <stark(at)enterprisedb(dot)com> |
| Subject: | Re: More logging for autovacuum |
| Date: | 2007-08-07 15:01:36 |
| Message-ID: | 200708071701.39239.dfontaine@hi-media.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Le mardi 07 août 2007, Tom Lane a écrit :
> Gregory Stark <stark(at)enterprisedb(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2007-08-07 15:23:50 | Re: More logging for autovacuum |
| Previous Message | Heikki Linnakangas | 2007-08-07 14:40:12 | Re: HOT pgbench results |