Re: Perl + Determine active connections on Pg 8.0.x and Pg 8.2.x

Richard Huxton <dev@archonet.com> writes:
> CAJ CAJ wrote:
>> SELECT count(*) from pg_stat_activity;
>>
>> The above query always returns 0 rows for Pg 8.0.x and 1 row for Pg 8.2.x.

> The pg_stat_activity view is never completely up-to-date, there is
> always some time lag.

It *is* up-to-date as of 8.2, but in prior releases there can be as much
as half a second time lag.

            regards, tom lane