Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3

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