Re: Added columns to pg_stat_activity

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Added columns to pg_stat_activity
Дата
Msg-id 427ECC1F.20900@samurai.com
обсуждение исходный текст
Ответ на Re: Added columns to pg_stat_activity  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Added columns to pg_stat_activity  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Tom Lane wrote:
> I'd vote against that.  The mechanism is lossy by design

Is it _lossy_, or merely unordered? While UDP doesn't guarantee message
delivery, I wonder what kind of extreme circumstances would need to
exist for you to lose UDP packets outright over the loopback interface.

 > I don't think it's acceptable to refuse to display information
> we do have (queries, access counts) just because we don't have every
> element of a rather-arbitrarily-chosen view row.

Is there really any point in returning such incomplete statistics data?
ISTM it would mostly serve to complicate the lives of people writing
automated tools to query statistics data, for example.

> Looking at the code, backendid seems sufficient since that is the
> lookup key.

Not if you want to distinguish between dead and live backends, it's not
(see pgstat_add_backend).

-Neil

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Added columns to pg_stat_activity
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Added columns to pg_stat_activity