| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Autovacuum on by default? |
| Date: | 2006-08-18 00:01:00 |
| Message-ID: | 200608180001.k7I010U26875@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > Agreed. I just IM'ed Alvaro and he says pg_stat_activity should now
> > show exactly what autovacuum is doing (and if it doesn't, let's fix it).
> > I think that is the best solution to the monitoring problem, rather than
> > throwing lines in the server logs.
>
> How do you figure that? The point of logging what's done is so that you
> can find out what autovac has been doing, not what it's doing right now.
I don't think the server logs is the place to record history autovacuum
activity. I am not saying we might not need that functionality, but not
in the server logs, and I think others seem to agree.
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florian G. Pflug | 2006-08-18 00:02:30 | Re: [PATCHES] WIP archive_timeout patch |
| Previous Message | Tom Lane | 2006-08-17 23:11:25 | Re: [PATCHES] WIP archive_timeout patch |