Cancelled Vacuum Leaving Tables Locked?

From: Orion Henry <orion(at)trustcommerce(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Cancelled Vacuum Leaving Tables Locked?
Date: 2001-11-28 01:22:07
Message-ID: 9u1dqr$28km$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am running postgresql-7.1.3-1PGDG on RedHat Linux 6.2

If I start a "VACUUM ANALYZE" and later hit Ctrl-C to
stop it, the table that was in mid-vacuum seems to
say locked. Any opperation on the table after that point
takes far longer than I am willing to wait. A clean
restart fixes the problem.

Is this a bug? Ideas?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mayan 2001-11-28 04:38:44 Starting PosgreSQL at bootup time
Previous Message Tom Lane 2001-11-27 22:08:32 Re: [HACKERS] How to turn off TOAST on a table/column