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. 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? -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
