Re: Added columns to pg_stat_activity

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Added columns to pg_stat_activity
Дата
Msg-id 427F4A9C.3040303@samurai.com
обсуждение исходный текст
Ответ на Re: Added columns to pg_stat_activity  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Added columns to pg_stat_activity
Список pgsql-patches
Tom Lane wrote:
> If the stats collector gets sufficiently backed up, you will lose
> messages. [...] Please do not try to make piecemeal changes in that
> basic design decision.

Fair enough.

 > (Actually, we could skinny it down to backend PID only ...
> but that would add a hashtable lookup to every message reception in
> the stats collector, instead of just indexing into a BackendId array,
> so it'd probably be a net loss.)

Yeah, I agree -- backend ID and database ID isn't too bad.

I've applied Magnus patch and bumped the catalog version. I'll take a
look at reorganizing the statistics collector so that the message header
is smaller shortly.

-Neil

В списке pgsql-patches по дате отправления:

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Updated kerberos service name patch
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Added columns to pg_stat_activity