Re: Idle transactions - Mailing list pgsql-admin

From Thomas Markus
Subject Re: Idle transactions
Date
Msg-id 46E67DE5.4080506@proventis.net
Whole thread Raw
In response to Idle transactions  (Mateus Interciso <p.zarnick@gmail.com>)
List pgsql-admin
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
>



Attachment

pgsql-admin by date:

Previous
From: Mateus Interciso
Date:
Subject: Idle transactions
Next
From: Tino Schwarze
Date:
Subject: Re: Idle transactions