| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Mathieu De Zutter <mathieu(at)dezutter(dot)org> |
| Cc: | Georgi Ivanov <georgi(dot)r(dot)ivanov(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Idle connections |
| Date: | 2010-10-06 19:33:17 |
| Message-ID: | 4CACCEFD.3080101@iol.ie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)iol(dot)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(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vorpal | 2010-10-07 00:53:15 | How to I relocate the Postgresql data directory |
| Previous Message | Mathieu De Zutter | 2010-10-06 19:26:30 | Re: Idle connections |