Anony Mous wrote:
Thanks, Richard.
I've never seen this behaviour before in 7.4.3 and indeed it is the only
connection to the back end at the time when the count is occurring. However,
it would have had the connection for at least 30 seconds before requesting a
count.
Is there a better method of
g the number of connections to the
backend?
Thanks
Peter
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: August 19, 2004 2:21 AM
To: Anony Mous
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] select count(*) from pg_stat_activity in V8.0.0
Anony Mous wrote:
> Comin
Richard Huxton <[EMAIL PROTECTED]> 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 be
