Postgres Pro
Downloads
Home   >   mailing lists

Cancelled Vacuum Leaving Tables Locked? - Mailing list pgsql-general

From Orion Henry
Subject Cancelled Vacuum Leaving Tables Locked?
Date
Msg-id 9u1dqr$28km$1@news.tht.net
Whole thread Raw
Responses Re: Cancelled Vacuum Leaving Tables Locked?
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: "Steve Brett"
Date:
Subject: Re: Timing a query
Next
From: Mayan
Date:
Subject: Starting PosgreSQL at bootup time