Re: Idle connections

From: Mathieu De Zutter <mathieu(at)dezutter(dot)org>
To: rod(at)iol(dot)ie
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:26:30
Message-ID: AANLkTi=YctLO2j6qDt4CrE-2TFqB_g1uQL3TG0_=Gr-7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Regards,
Mathieu

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2010-10-06 19:33:17 Re: Idle connections
Previous Message Raymond O'Donnell 2010-10-06 18:40:29 Re: Why i see several postgres server processes sometimes ?