Re: Idle connections - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Idle connections
Date
Msg-id 4CACCEFD.3080101@iol.ie
Whole thread Raw
In response to Re: Idle connections  (Mathieu De Zutter <mathieu@dezutter.org>)
Responses Re: Idle connections  ("mark" <dvlhntr@gmail.com>)
List pgsql-general
On 06/10/2010 20:26, Mathieu De Zutter wrote:
> On Wed, Oct 6, 2010 at 3:33 PM, Raymond O'Donnell<rod@iol.ie>  wrote:
>> On 06/10/2010 14:26, Georgi Ivanov wrote:
>>>
>>> Hi,
>>> I have some issue where
>>> SELECT * from pg_stat_activity WHERE current_query='<IDLE>';
>>> returns too many rows .
>>> Any ideas why is this happening ?
>>
>> Are you using any kind of connection pooler?
>
> Maybe persistent DB connections on the webserver?

I was wondering about that too... I sent an email about it that doesn't
seem to have made it to the list. A little googling shows that PDO does
support persistent connections, so that could be it.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: Mathieu De Zutter
Date:
Subject: Re: Idle connections
Next
From: "Vorpal"
Date:
Subject: How to I relocate the Postgresql data directory