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.
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2010-04-30 18:39:41|
|Subject: Re: dump diffs even w/o db changes |
|Previous:||From: Tom Lane||Date: 2010-04-30 18:12:06|
|Subject: Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3 |