Postgres Pro
Downloads
Home   >   mailing lists

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 1131.1028906406@sss.pgh.pa.us
Whole thread Raw
In response to Re: What to do about a vacuum...  ("Robert M. Meyer" <rmeyer@installs.com>)
Responses Re: What to do about a vacuum...  ("Robert M. Meyer" <rmeyer@installs.com>)
Re: What to do about a vacuum...  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-admin
Tree view 
"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.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Robert M. Meyer"
Date:
Subject: Re: What to do about a vacuum...
Next
From: "Robert M. Meyer"
Date:
Subject: Re: What to do about a vacuum...