Re: full vacuum cancelation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: full vacuum cancelation
Дата
Msg-id 23760.1287673203@sss.pgh.pa.us
обсуждение исходный текст
Ответ на full vacuum cancelation  (Viktor Bojović <viktor.bojovic@gmail.com>)
Ответы Re: full vacuum cancelation  (Viktor Bojović <viktor.bojovic@gmail.com>)
Список pgsql-general
=?UTF-8?Q?Viktor_Bojovi=C4=87?= <viktor.bojovic@gmail.com> writes:
> my full vacuuming of one table runs still after four days. Is it safe to
> cancel it by pressing Ctrl+c?

I assume this is a pre-9.0 Postgres version?

Depending on how far along the vacuum actually is, there's a possibility
that trying to cancel it will cause a PANIC, but that will not damage
your data --- the worst consequence would be killing any other sessions
that are running concurrently.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Custom cache implemented in a postgresql C function
Следующее
От: David Kerr
Дата:
Сообщение: Re: Generate a dynamic sequence within a query