Re: [DOC] Document concurrent index builds waiting on each other

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [DOC] Document concurrent index builds waiting on each other
Дата
Msg-id 20190930012406.GC2888@paquier.xyz
обсуждение исходный текст
Ответ на Re: [DOC] Document concurrent index builds waiting on each other  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: [DOC] Document concurrent index builds waiting on each other  (James Coleman <jtc331@gmail.com>)
Re: [DOC] Document concurrent index builds waiting on each other  (James Coleman <jtc331@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Sat, Sep 28, 2019 at 10:22:28PM -0300, Alvaro Herrera wrote:
> I always thought that create index concurrently was prevented from
> running concurrently in a table by the ShareUpdateExclusive lock that's
> held during the operation.

REINDEX CONCURRENTLY and CIC can deadlock while waiting for each other
to finish after their validation phase, see:
https://www.postgresql.org/message-id/20190507030756.GD1499@paquier.xyz
https://www.postgresql.org/message-id/20190507032543.GH1499@paquier.xyz
--
Michael
Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: pg_wal/RECOVERYHISTORY file remains after archive recovery
Следующее
От: Chapman Flack
Дата:
Сообщение: documentation inconsistent re: alignment