Idle transactions - Mailing list pgsql-admin

From Mateus Interciso
Subject Idle transactions
Date
Msg-id fc5td9$o66$1@sea.gmane.org
Whole thread Raw
Responses Re: Idle transactions  (Thomas Markus <t.markus@proventis.net>)
Re: Idle transactions  (Tino Schwarze <postgresql@tisc.de>)
List pgsql-admin
Hello, it's been a while that I'm seeing that our servers running JBoss
with PostgreSQL, after some hours of work, have at least 70 or more
"<IDLE> in transaction" status for transactions, and this is bogging down
our servers.
Is this normal behaviour? If not, is there anything I can do to prevent
it? Why is it happening? What's a transaction that is "<IDLE> in
transaction" actually really means?

Thanks a lot.

Mateus.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Close open transactions soon to avoid wraparound problems
Next
From: Thomas Markus
Date:
Subject: Re: Idle transactions