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
Lewis Kapell
Vladimir Rusinov wrote:
Hi!
We are having a lot of '<IDLE> in transaction' processes in production
database. This does not seems to be big problem now, since they are not
taking any big locks. But I'm aware that sometime it can become a
problem. Currently I'm just killing all processes that are in 'idle in
transaction' for more than 1 minute.
Our application is quite big and complex, so it's not easy to find peace
of code where it happens. How can I get transaction history for
processes that idle in transaction to send it to developers so they can
find problem in code.
We are running postgresql 8.3 with query logging off (turning it on
causes performance disaster). Application is run under jboss and AFAIK
uses hibernate.
--
Vladimir Rusinov
http://greenmice.info/
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
