Re: What to do about a vacuum... - Mailing list pgsql-admin

From Tom Lane
Subject Re: What to do about a vacuum...
Date
Msg-id 418.1028900838@sss.pgh.pa.us
Whole thread Raw
In response to What to do about a vacuum...  ("Robert M. Meyer" <rmeyer@installs.com>)
Responses Re: What to do about a vacuum...
List pgsql-admin
"Robert M. Meyer" <rmeyer@installs.com> writes:
> IN my infinite wisdom, in an effort to resolve my performance problems,
> I started a full vacuum of my database last night around 4:00AM.  It's
> still running at 9;20AM and it has all of the tables locked.

Huh?  Vacuum should only lock one table at a time.

> Is it safe to cancel the query from inside pgmonitor?

Yes, a SIGINT should be safe enough.  You'll lose the benefit of whatever
vacuuming work has been done so far on the current table.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Robert M. Meyer"
Date:
Subject: What to do about a vacuum...
Next
From: "Robert M. Meyer"
Date:
Subject: Re: What to do about a vacuum...