Re: Autovacuum deadlock - bug or not?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Autovacuum deadlock - bug or not?
Дата
Msg-id 25956.1132239070@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Autovacuum deadlock - bug or not?  ("Mikael Carneholm" <Mikael.Carneholm@WirelessCar.com>)
Список pgsql-bugs
"Mikael Carneholm" <Mikael.Carneholm@WirelessCar.com> writes:
> Don't know if this is a bug or just undocumented, but it seems as you should turn off autovacuum before you run
CLUSTER,otherwise you might run into a deadlock: 

Which variant of CLUSTER were you using?  ISTR that some of them lock
the index before the table, which is prone to deadlock against nearly
all other operations on the table (not just vacuum).

            regards, tom lane

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

Предыдущее
От: "Mikael Carneholm"
Дата:
Сообщение: Autovacuum deadlock - bug or not?
Следующее
От: "Mikael Carneholm"
Дата:
Сообщение: Re: Autovacuum deadlock - bug or not?