Re: What to do about a vacuum...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: What to do about a vacuum...
Date: 2002-08-09 16:31:09
Message-ID: 4030.1028910669@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Andrew Sullivan <andrew(at)libertyrms(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jie Liang 2002-08-09 18:09:07 Another possible bug in pg_restore
Previous Message Andrew Sullivan 2002-08-09 15:36:51 Re: What to do about a vacuum...