Re: [GENERAL] VACUUM is hanging

[David Wall]

> 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



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster