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 problem)
Any help here is appreciated
Thanks
Sriram