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