Re: fighting '<IDLE> in transaction'

From: Vladimir Rusinov <vladimir(at)greenmice(dot)info>
To: Lewis Kapell <lkapell(at)setonhome(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: fighting '<IDLE> in transaction'
Date: 2009-11-05 14:16:53
Message-ID: f6fdfb550911050616p2c99ab60k7865bf1dd2bbe4ce@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Nov 3, 2009 at 5:54 PM, Lewis Kapell <lkapell(at)setonhome(dot)org> wrote:

> Please see these earlier threads:
>
> Is IDLE session really idle?
> http://archives.postgresql.org/pgsql-admin/2009-06/msg00096.php
>
> Idle connections
> http://archives.postgresql.org/pgsql-admin/2009-10/msg00017.php
>

Thanks - that was useful reading, but not related to my issue. There are not
a lot of IDLE sessions: connection pools are configured accurate. There are
problems with 'IDLE *in transaction*' sessions, which I believe may cause
strong lock problems.

--
Vladimir Rusinov
http://greenmice.info/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tomeh, Husam 2009-11-05 16:29:50 Re: Help ! Service fails to start
Previous Message ABBAS SHAKEEL 2009-11-05 10:45:36 Re: Syncronizing Databases at different Remote Location