Re: autovacuum "connections" are hidden - Mailing list pgsql-general

From Bruce Momjian
Subject Re: autovacuum "connections" are hidden
Date
Msg-id 200605181707.k4IH7Al19847@candle.pha.pa.us
Whole thread Raw
In response to Re: autovacuum "connections" are hidden  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Alvaro Herrera wrote:
> Larry Rosenman wrote:
> > Bruce Momjian wrote:
> > > Tom Lane wrote:
> > >> Casey Duncan <casey@pandora.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. +

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: autovacuum "connections" are hidden
Next
From: Tom Lane
Date:
Subject: Re: autovacuum "connections" are hidden