Re: VACUUM is hanging - jdbc?

From: "David Wall" <dwall(at)Yozons(dot)com>
To: "Postgres General List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: VACUUM is hanging - jdbc?
Date: 2001-05-05 03:06:15
Message-ID: 007401c0d510$58ea0a60$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 David Wall 2001-05-05 03:07:04 Re: VACUUM is hanging
Previous Message Ashley Clark 2001-05-05 02:44:10 Re: VACUUM is hanging