Re: What to do about a vacuum...

From: "Robert M(dot) Meyer" <rmeyer(at)installs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: What to do about a vacuum...
Date: 2002-08-09 15:21:34
Message-ID: 1028906495.28141.10.camel@skymaster
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Yes, I checked it. Tried three times. It's not listening and it's got
>96% of one of the CPUs. I'm about to try the 'terminate' button in
pgmonitor. It ignored the 'Cancel button'.

Cheers!

Bob

On Fri, 2002-08-09 at 11:20, 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.
>
> regards, tom lane
--
Robert M. Meyer
Sr. Network Administrator
DigiVision Satellite Services
14 Lafayette Sq, Ste 410
Buffalo, NY 14203-1904
(716)332-1451

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2002-08-09 15:36:51 Re: What to do about a vacuum...
Previous Message Tom Lane 2002-08-09 15:20:06 Re: What to do about a vacuum...