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: f6fdfb550911050616p2c99ab60k7865bf1dd2bbe4ce@mail.gmail.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group