Re: What to do about a vacuum...

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: What to do about a vacuum...
Date: 2002-08-09 15:36:51
Message-ID: 20020809113651.A7239@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Aug 09, 2002 at 11:20:06AM -0400, Tom Lane wrote:
> "Robert M. Meyer" <rmeyer(at)installs(dot)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(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-08-09 16:31:09 Re: What to do about a vacuum...
Previous Message Robert M. Meyer 2002-08-09 15:21:34 Re: What to do about a vacuum...