Commit gets locked until vacuum is performed - Mailing list pgsql-jdbc

From Xavier Santana
Subject Commit gets locked until vacuum is performed
Date
Msg-id 4C3AF329.30200@slash-solutions.com
Whole thread Raw
Responses Re: Commit gets locked until vacuum is performed  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Commit gets locked until vacuum is performed  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Hi all,

I'm using JDBC driver 8.1-413.jdbc3 to access a PostgreSQL 8.1.3
database on windows.
Sometimes, when my application performs a commit of a transaction with
maybe 100 or 200 inserts, the operation gets locked, with no error
message or exception.
When that happens, if I perform a vacuum over the database (for example
from pgAdmin), the operation unlocks and the commit finishes correctly.

Any idea of what can be happening?

Thanks in advance.

Xavier


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Trying to accomplish SSO from Windows
Next
From: "Kevin Grittner"
Date:
Subject: Re: Commit gets locked until vacuum is performed