Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3 - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3
Date
Msg-id 4BDAD9440200002500031112@gw.wicourts.gov
Whole thread Raw
In response to Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3  (Jason Culverhouse <Jason@Mischievous.org>)
List pgsql-admin
Jason Culverhouse <Jason@Mischievous.org> wrote:

> The server is postgres 8.3 on ubuntu linux.

There have been a number of bugs fixed in vacuuming, including
autovacuum, since the original 8.3 release.  I hope you mean
8.3.somethingrecent -- if not, you should get the latest fixes.

> Can I safely kill the vacuum with:
>   select pg_cancel_backend(26433)

That is safe.  If it doesn't work, you may need a bigger hammer.

-Kevin

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3
Next
From: Tom Lane
Date:
Subject: Re: dump diffs even w/o db changes