Re: Commit gets locked until vacuum is performed

Xavier Santana <xsantana@slash-solutions.com> wrote:

> I'm using JDBC driver 8.1-413.jdbc3 to access a PostgreSQL 8.1.3
> database on windows.

Version 8.1.anything is not supported on Windows:

http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy

8.1.3 is a very old version of that major release with many known bugs
fixed in later minor releases.

http://www.postgresql.org/support/versioning
http://www.postgresql.org/docs/8.1/static/release.html

The recommended JDBC driver for that PostgreSQL version is 8.4-701:

http://jdbc.postgresql.org/download.html#current

Given what you're running, it's amazing that is your biggest problem.
Please update as soon as possible, at least to 8.2.something-recent.

-Kevin