> 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
- [GENERAL] VACUUM is hanging Ashley Clark
- Re: [GENERAL] VACUUM is hanging Tom Lane
- [GENERAL] Re: VACUUM is hanging Ashley Clark
- Re: [GENERAL] Re: VACUUM is hanging Tom Lane
- Re: [GENERAL] Re: VACUUM is hanging Neil Conway
- Re: [GENERAL] VACUUM is hanging - jdbc? David Wall
- Re: [GENERAL] VACUUM is hanging - jdbc? David Wall