Sharma, Sid wrote:
Sorry. Forgot to mention the postgres version
PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96
Why on earth are you using that version? At the very least upgrade to
8.1.17 and if this is a new app, why not use 8.4?
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.
You don't say how you are connecting to the DB, but it's probably your
connection manager. Are you running some sort of connection pooling perhaps?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
