| From: | Feite Brekeveld <feite(dot)brekeveld(at)osiris-it(dot)nl> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: vacuum job taking very long time to complete |
| Date: | 2001-06-27 20:52:56 |
| Message-ID: | 3B3A47A8.D6C259C7@osiris-it.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> Feite Brekeveld <feite(dot)brekeveld(at)osiris-it(dot)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(dot)brekeveld(at)osiris-it(dot)nl
http://www.osiris-it.nl
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= | 2001-06-27 21:01:19 | Re: Re: Red Hat to support PostgreSQL |
| Previous Message | Bruce Momjian | 2001-06-27 20:51:23 | Re: Re: Red Hat to support PostgreSQL |