Re: vacuum job taking very long time to complete

Feite Brekeveld <feite.brekeveld@osiris-it.nl> writes:
> I still have 3.5 G available for logfiles but suppose there is a chance
> that I will run out of diskspace before the vacuum is done , can I kill
> it safely before that happens ?

Yes, you can just send a SIGINT to the vacuuming backend (or type
control-C in psql, if you issued the vacuum command from psql).

You may care to apply the patch in
http://www.ca.postgresql.org/mhonarc/pgsql-patches/2001-06/msg00061.html
before trying again.

            regards, tom lane