Re: What to do about a vacuum...

On Fri, Aug 09, 2002 at 11:20:06AM -0400, Tom Lane wrote:
> "Robert M. Meyer" <rmeyer@installs.com> writes:
> > Well, 'kill -INT pid' doesn't seem to have worked.  This is 7.2.1.  We
> > really don't want to whack the system but we need to get back online...
>
> You sure you sigint'ed the right process?  I can't see that VACUUM could
> take more than a few seconds to respond to a cancel --- it checks before
> moving onto each new page.

Will vacuum respond to SIGINT if it's blocked waiting for a
transaction to commit?

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110