Re: VACUUM is hanging - jdbc? - Mailing list pgsql-general

From David Wall
Subject Re: VACUUM is hanging - jdbc?
Date
Msg-id 007401c0d510$58ea0a60$5a2b7ad8@expertrade.com
Whole thread Raw
In response to VACUUM is hanging  (Ashley Clark <aclark@ghoti.org>)
List pgsql-general
> Try not to leave open transactions hanging around in your Apache code.
> An idle database connection couldn't block VACUUM like that; it'd have
> to have been in the middle of a BEGIN block, or maybe even an unfinished
> query.

It's possible that the JDBC library always creates a new transaction after a
commit/rollback. It wouldn't have any locks or the like, though.

David


pgsql-general by date:

Previous
From: Ian Harding
Date:
Subject: Re: Accounting Schema
Next
From: Lieven Van Acker
Date:
Subject: views & triggers