Re: Connection Idle in transaction

Поиск
Список
Период
Сортировка
От David Wall
Тема Re: Connection Idle in transaction
Дата
Msg-id 024e01c41dd2$046852e0$3201a8c0@rasta
обсуждение исходный текст
Ответ на Connection Idle in transaction  (Gaetano Mendola <mendola@bigfoot.com>)
Ответы Re: Connection Idle in transaction
Re: Connection Idle in transaction
Список pgsql-jdbc
> Not block sorry, but the vacuum is not able to free all the row updated
> by other connections.

But each connection shouldn't have any updated rows that haven't been
committed or rolled back.  Now, if you are running some statements against a
connection and then never calling commit/rollback, that's another thing
since you are actually tying up resources then.  But since the driver just
does a 'begin' after any given commit/rollback, there shouldn't be anything
locked by that connection.

David


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: Connection Idle in transaction
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: Connection Idle in transaction