Alvaro Herrera wrote: > Larry Rosenman wrote: > > Bruce Momjian wrote: > > > Tom Lane wrote: > > >> Casey Duncan <casey@xxxxxxxxxxx> 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. +
