Re: vacuumdb parallel has a deadlock detected in 9.5.4

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: vacuumdb parallel has a deadlock detected in 9.5.4
Дата
Msg-id 20160928172551.bxetdmwm7xwy74ue@depesz.com
обсуждение исходный текст
Ответ на vacuumdb parallel has a deadlock detected in 9.5.4  (huang <foggyglass@163.com>)
Ответы Re: vacuumdb parallel has a deadlock detected in 9.5.4
Список pgsql-bugs
On Wed, Sep 28, 2016 at 09:46:22PM +0800, huang wrote:
>  Hi friends,
>
> There is a error deadlock detected in vacuumdb parallel .
> but if I do not use parallel , it has not deadlock detected .

man vacuumdb says about -j option:

>> Note that using this mode together with the -f (FULL) option might cause
>> deadlock failures if certain system catalogs are processed in parallel.

so, while I understand it's not pretty, it's well documented.

Best regards,

depesz

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

Предыдущее
От: huang
Дата:
Сообщение: vacuumdb has a fatal after database rename
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: vacuumdb has a fatal after database rename