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
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.
pgsql-admin by date
|Next:||From: Thomas Markus||Date: 2007-09-11 11:37:09|
|Subject: Re: Idle transactions|
|Previous:||From: Tom Lane||Date: 2007-09-11 01:54:05|
|Subject: Re: Close open transactions soon to avoid wraparound problems |