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

Idle transactions

From: Mateus Interciso <p(dot)zarnick(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Idle transactions
Date: 2007-09-11 11:15:54
Message-ID: fc5td9$o66$1@sea.gmane.org (view raw or flat)
Thread:
Lists: 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.


Responses

pgsql-admin by date

Next:From: Thomas MarkusDate: 2007-09-11 11:37:09
Subject: Re: Idle transactions
Previous:From: Tom LaneDate: 2007-09-11 01:54:05
Subject: Re: Close open transactions soon to avoid wraparound problems

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