On Tue, Nov 3, 2009 at 5:54 PM, Lewis Kapell <lkapell@xxxxxxxxxxxxx> wrote:
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.
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/
