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 по дате отправления: