Re: What to do about a vacuum... - Mailing 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