"Robert M. Meyer" <rmeyer(at)installs(dot)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