Commit gets locked until vacuum is performed

From: Xavier Santana <xsantana(at)slash-solutions(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Commit gets locked until vacuum is performed
Date: 2010-07-12 10:49:13
Message-ID: 4C3AF329.30200@slash-solutions.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kevin Grittner 2010-07-12 17:52:20 Re: Commit gets locked until vacuum is performed
Previous Message Kris Jurka 2010-07-09 23:30:32 Re: Trying to accomplish SSO from Windows