Re: Idle in transaction

["Sharma, Sid" <ssharma@xxxxxxx>]

Sorry. Forgot to mention the postgres version

PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96

 

---

From: Sharma, Sid
Sent: Friday, July 17, 2009 10:05 AM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Idle in transaction

 

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