> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Wednesday, October 06, 2010 11:14 PM
> To: mark
> Cc: r...@iol.ie; 'Mathieu De Zutter'; 'Georgi Ivanov'; pgsql-
> gene...@postgresql.org
> Subject: Re: [GENERAL] Idle connec
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wednesday, October 06, 2010 11:14 PM
To: mark
Cc: r...@iol.ie; 'Mathieu De Zutter'; 'Georgi Ivanov';
pgsql-general@postgresql.org
Subject: Re: [GENERAL] Idle connections
>What you're desc
"mark" writes:
> If you get to many persistent or otherwise idle connections you might be
> inducing a "thundering herd" condition. Seems like on our servers we hit a
> wall with just having a lot of persistent connections from various apps. I
> don't really understand everything involved here but
f Raymond O'Donnell
Sent: Wednesday, October 06, 2010 1:33 PM
To: Mathieu De Zutter
Cc: Georgi Ivanov; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Idle connections
On 06/10/2010 20:26, Mathieu De Zutter wrote:
> On Wed, Oct 6, 2010 at 3:33 PM, Raymond O'Donnell wrote:
>>
On 06/10/2010 20:26, Mathieu De Zutter wrote:
On Wed, Oct 6, 2010 at 3:33 PM, Raymond O'Donnell wrote:
On 06/10/2010 14:26, Georgi Ivanov wrote:
Hi,
I have some issue where
SELECT * from pg_stat_activity WHERE current_query='';
returns too many rows .
Any ideas why is this happening ?
Are y
On Wed, Oct 6, 2010 at 3:33 PM, Raymond O'Donnell wrote:
> On 06/10/2010 14:26, Georgi Ivanov wrote:
>>
>> Hi,
>> I have some issue where
>> SELECT * from pg_stat_activity WHERE current_query='';
>> returns too many rows .
>> Any ideas why is this happening ?
>
> Are you using any kind of connecti
On 06/10/2010 14:26, Georgi Ivanov wrote:
Hi,
I have some issue where
SELECT * from pg_stat_activity WHERE current_query='';
returns too many rows .
What do you mean by "too many"?
What is the meaning of IDLE ?
It means a client is keeping a connection open, but not executing any
queries.
Hi,
I have some issue where
SELECT * from pg_stat_activity WHERE current_query='';
returns too many rows .
What is the meaning of IDLE ?
I suspect that the server is overloaded with idle connections, but i don't
know why .
Sometimes i am forced to do
SELECT pg_terminate_backend(procpid) from pg_s
Hello,
After using Postgresql for a while, through ODBC / MS Access, I'm not
able to connect to the server anymore. The server reports "Too many
clients connected already".
With a "ps -afx", I can see a lot of idle postgresql connections, which
correspond for sure to ODBC connections that haven't
