Re: Connection Idle in transaction

From: "David Wall" <d(dot)wall(at)computer(dot)org>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Connection Idle in transaction
Date: 2004-04-09 01:28:06
Message-ID: 024e01c41dd2$046852e0$3201a8c0@rasta
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-04-09 01:46:41 Re: Connection Idle in transaction
Previous Message Gaetano Mendola 2004-04-09 00:29:44 Re: Connection Idle in transaction