Search Postgresql Archives

Re: autovacuum "connections" are hidden

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux