Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
