Re: vacuum process stuck

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: vacuum process stuck
Дата
Msg-id 8155.1054092646@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: vacuum process stuck  (Doug Silver <dsilver@urchin.com>)
Список pgsql-novice
Doug Silver <dsilver@urchin.com> writes:
>> Any suggestions?  I assume I absolutely should not kill the postgresql
>> process that is running the request, so what are some other options?

> After another 45 minutes or so, it finally quit and I was able to restart
> postgresql and run vacuum db.  A little patience was the best thing in this
> case!

FWIW, killing a vacuum isn't any more dangerous than killing anything
else.  It should just work...

            regards, tom lane

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

Предыдущее
От: "Richard Hall"
Дата:
Сообщение: Functions calling Functions
Следующее
От: Herbie McDuck
Дата:
Сообщение: nOOb Alert..Need some help..