Can concurrent create index concurrently block each other?

Поиск
Список
Период
Сортировка
От Konstantin Knizhnik
Тема Can concurrent create index concurrently block each other?
Дата
Msg-id 648d168a-d34b-42bb-bef6-34074d5236e5@garret.ru
обсуждение исходный текст
Ответы Re: Can concurrent create index concurrently block each other?
Re: Can concurrent create index concurrently block each other?
Список pgsql-hackers

One our customer complains that he spawned two `create index concurrently` for two different tables and both stuck in "waiting for old snapshots".
I wonder if two CIC can really block each other in `
WaitForOlderSnapshots`?
I found the similar question in hacker archive:

https://www.postgresql.org/message-id/flat/MWHPR20MB1421AEC7CEC67B159AC188F6A19A0%40MWHPR20MB1421.namprd20.prod.outlook.com

but it is quite old (2016). Was the problem fixed since that time? And if not, why there it is not mentioned in CIC documentation that performing several CIC in parallel can cause "deadlock"?

Thanks in advance,
Konstantin

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

Предыдущее
От: "Imseih (AWS), Sami"
Дата:
Сообщение: Re: Logging parallel worker draught
Следующее
От: Avinash Vallarapu
Дата:
Сообщение: Re: Can concurrent create index concurrently block each other?