Idle in transaction

From: "Sharma, Sid" <ssharma(at)bjs(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Idle in transaction
Date: 2009-07-17 14:05:24
Message-ID: ACFDE9C6BE48D9498A073197F80ED98C080DF671@EXVIP3.bjw2k.asg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I'm a postgres newbie. I just implemented a new web application using
postgres.

When I look at the db connections (via ps), I notice that all existing
connections are in 'Idle in Transaction' state.

They never go to idle state.

The application itself remains functional and responsive. It has been up
for over 36 hours now without any issues.

What is the significance of this state? Does this imply a transaction
leak? Then why am I not noticing deadlocks, timeouts etc.

Thanks

Sid

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tanjunhua 2009-07-17 14:11:54 memory leak occur when disconnect database
Previous Message Richard Huxton 2009-07-17 07:29:59 Re: something to suggest indexes