Jason Culverhouse <Jason@xxxxxxxxxxxxxxx> writes: > I have a vacuum process that has been running on a table for the past 20 days. > The server is postgres 8.3 on ubuntu linux. > Can I safely kill the vacuum with: > select pg_cancel_backend(26433) Sure. 20 days is a long time. Is it actually running, or blocked on a lock? If not blocked, I have to guess that you've chosen very poor vacuum delay settings. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
