I use postgres 8.1.2 database and postgres 8.1.404 jdbc driver .
I keep seeing "idle in transaction" connections on the postgres box all
the time. The application logic closes all connections , so it makes me
wonder if the driver is issuing a begin statement after every commit to
leave a floating transaction open.
This is causing autovacuum to not finish (and hence I have to frequently
issue database-wide vacuums to prevent the transaction id wraparound
Any help here is appreciated
pgsql-jdbc by date
|Next:||From: Markus Schaber||Date: 2006-09-16 08:26:48|
|Subject: Re: idle in transaction|
|Previous:||From: Marc Herbert||Date: 2006-09-15 10:17:46|
|Subject: Re: about monitoring the input stream|