Re: select count(*) from pg_stat_activity in V8.0.0

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: select count(*) from pg_stat_activity in V8.0.0
Дата
Msg-id 15594.1092925503@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: select count(*) from pg_stat_activity in V8.0.0  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Дерево обсуждения 
Richard Huxton <dev@archonet.com> writes:
> Anony Mous wrote:
>> select count(*) from pg_stat_activity

> Do you have multiple live connections? My understanding of
> pg_stat_activity is that it can lag slightly behind the current state of
> the system.

If memory serves, it's up to 500 msec behind.  So this technique has
never been 100% accurate.  I'm not sure why A.Mous failed to observe the
inaccuracy before ...

            regards, tom lane

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

Предыдущее
От: Marcel Boscher
Дата:
Сообщение: Finally tsearch works ... somehow... remain a few questions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: possible bug in exception handling code? (postgres8.0beta)