Re: vacuum job taking very long time to complete

Поиск
Список
Период
Сортировка
От Feite Brekeveld
Тема Re: vacuum job taking very long time to complete
Дата
Msg-id 3B3A47A8.D6C259C7@osiris-it.nl
обсуждение исходный текст
Ответ на vacuum job taking very long time to complete  (Feite Brekeveld <feite.brekeveld@osiris-it.nl>)
Список 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 по дате отправления:

Предыдущее
От: Alex Knight
Дата:
Сообщение: Re: Re: Red Hat to support PostgreSQL
Следующее
От: Lamar Owen
Дата:
Сообщение: Re: Re: Red Hat to support PostgreSQL