Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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?
> Idle connections

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

In response to


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group