Re: [HACKERS] Simultaneous index creates on different schemas cause deadlock?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Simultaneous index creates on different schemas cause deadlock?
Дата
Msg-id 17038.1366919695@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Simultaneous index creates on different schemas cause deadlock?  ("anarazel@anarazel.de" <andres@anarazel.de>)
Список pgsql-admin
Дерево обсуждения 
"anarazel@anarazel.de" <andres@anarazel.de> writes:
> I don't have access to the code ATM an I wonder whether DROP CONCURRENTLY has a similar problem? Depends a bit on how
thewaiting is done... 

It's not a problem --- that code doesn't depend on waiting for snapshots
to expire, it just checks for other sessions holding locks on the target
table.  (I also did some experimental testing to verify this.)

            regards, tom lane

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

Предыдущее
От: "anarazel@anarazel.de"
Дата:
Сообщение: Re: [HACKERS] Simultaneous index creates on different schemas cause deadlock?
Следующее
От: Strahinja Kustudić
Дата:
Сообщение: Re: archive falling behind