Skip site navigation (1) Skip section navigation (2)

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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Jason Culverhouse" <Jason(at)Mischievous(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3
Date: 2010-04-30 18:21:08
Message-ID: 4BDAD9440200002500031112@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Jason Culverhouse <Jason(at)Mischievous(dot)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

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2010-04-30 18:39:41
Subject: Re: dump diffs even w/o db changes
Previous:From: Tom LaneDate: 2010-04-30 18:12:06
Subject: Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group