Commit gets locked until vacuum is performed

Поиск
Список
Период
Сортировка
От Xavier Santana
Тема Commit gets locked until vacuum is performed
Дата
Msg-id 4C3AF329.30200@slash-solutions.com
обсуждение исходный текст
Ответы Re: Commit gets locked until vacuum is performed
Re: Commit gets locked until vacuum is performed
Список 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 по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: Trying to accomplish SSO from Windows
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Commit gets locked until vacuum is performed