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 4030.1028910669@sss.pgh.pa.us
Whole thread Raw
In response to Re: What to do about a vacuum...  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-admin
Andrew Sullivan <andrew@libertyrms.info> writes:
> On Fri, Aug 09, 2002 at 11:20:06AM -0400, Tom Lane wrote:
>> 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?

I believe so --- that's just a special case of waiting for a lock, and
SIGINT should be able to interrupt anything that's waiting for a lock.

            regards, tom lane

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: What to do about a vacuum...
Next
From: Jie Liang
Date:
Subject: Another possible bug in pg_restore