Re: autovacuum "connections" are hidden

Alvaro Herrera wrote:
> Larry Rosenman wrote:
> > Bruce Momjian wrote:
> > > Tom Lane wrote:
> > >> Casey Duncan <casey(at)pandora(dot)com> writes:
> > >>> however, when I did "select * from pg_stat_activity" on the pg
> > >>> server, it showed no connection to that db. Then I looked at the
> > >>> processes: tmp0% ps ax | grep test_seg1
> > >>> 10317 ? D 0:36 postgres: autovacuum process test_seg1
> > >>
> > >> Hmm, autovacuum won't show up in pg_stat_activity because it never
> > >> calls pgstat_report_activity(). Seems like maybe it should, though.
>
> Yep. I'll fix it. Should I backpatch to 8.1?
>
> > > If we do that, would it help people who are trying to determine if
> > > pg_autovacuum is running? Would the connection still appear while
> > > pg_autovacuum is sleeping?
> >
> > I believe while autovacuum is sleeping, the process is gone.
>
> Yes, which means that really autovacuum does not sleep (it just exits
> when it's done). Postmaster is the one who sleeps between autovac
> iterations.

Good, anyway, it would allow people to see _when_ autovacuum is
processing things.

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +