Re: autovacuum "connections" are hidden

Поиск
Список
Период
Сортировка
Искать
От
Casey Duncan
Тема
Re: autovacuum "connections" are hidden
Дата
в 12:52:04
Msg-id
595F2C2A-FF85-4542-9185-4EDDB6846450@pandora.com
Ответ на
Список
Дерево обсуждения
Re: autovacuum "connections" are hidden "Larry Rosenman" <lrosenman@pervasive.com>
Re: autovacuum "connections" are hidden Alvaro Herrera <alvherre@commandprompt.com>
Re: autovacuum "connections" are hidden Tom Lane <tgl@sss.pgh.pa.us>
Re: autovacuum "connections" are hidden Alvaro Herrera <alvherre@commandprompt.com>
Re: autovacuum "connections" are hidden Tom Lane <tgl@sss.pgh.pa.us>
Re: autovacuum "connections" are hidden Alvaro Herrera <alvherre@commandprompt.com>
Re: autovacuum "connections" are hidden Tom Lane <tgl@sss.pgh.pa.us>
Re: autovacuum "connections" are hidden "Jim C. Nasby" <jnasby@pervasive.com>
Re: autovacuum "connections" are hidden Bruce Momjian <pgman@candle.pha.pa.us>
On May 17, 2006, at 12:34 PM, Tom Lane wrote:

> Casey Duncan  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 по дате отправления
От: Martijn van Oosterhout
Дата:
Сообщение: Re: table variables
От: Emi Lu
Дата:
FAQ