Re: VACUUM is hanging

From: "David Wall" <d(dot)wall(at)computer(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: VACUUM is hanging
Date: 2001-05-05 03:07:04
Message-ID: 008201c0d510$7615b120$5a2b7ad8@expertrade.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-05-05 03:54:07 Re: Re: VACUUM is hanging
Previous Message David Wall 2001-05-05 03:06:15 Re: VACUUM is hanging - jdbc?