Re: vacuum job taking very long time to complete

Tom Lane wrote:

> 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).

What happens with the logs when you do that ? Are the cleaned up because of
SIGINT ?

>
>
> 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

--
Feite Brekeveld
feite.brekeveld@osiris-it.nl
http://www.osiris-it.nl