Re: vacuum job taking very long time to complete - Mailing list pgsql-general

From Feite Brekeveld
Subject Re: vacuum job taking very long time to complete
Date
Msg-id 3B3A47A8.D6C259C7@osiris-it.nl
Whole thread Raw
In response to vacuum job taking very long time to complete  (Feite Brekeveld <feite.brekeveld@osiris-it.nl>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Alex Knight
Date:
Subject: Re: Re: Red Hat to support PostgreSQL
Next
From: Lamar Owen
Date:
Subject: Re: Re: Red Hat to support PostgreSQL