Re: Idle transactions

Hi,

it means that a transaction isn't finished (commit/rollback). check your
application for long running operations or programmming errors.

tm

Mateus Interciso schrieb:
> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>