Re: autovacuum "connections" are hidden

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.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support