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

From Casey Duncan
Subject Re: autovacuum "connections" are hidden
Date
Msg-id 595F2C2A-FF85-4542-9185-4EDDB6846450@pandora.com
Whole thread Raw
In response to Re: autovacuum "connections" are hidden  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On May 17, 2006, at 12:34 PM, 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.

Is this worth filing a bug about for posterity?

-Casey


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: table variables
Next
From: Emi Lu
Date:
Subject: Re: RES: Add column and specify the column position in