Re: Deadlock between concurrent index builds on different tables

Поиск
Список
Период
Сортировка
От Jeremy Finzel
Тема Re: Deadlock between concurrent index builds on different tables
Дата
Msg-id CAMa1XUgN8eaSBba8bmOP7xXubGFCp1aECFR3029Yhfh_Y4v2yQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Deadlock between concurrent index builds on different tables  (Martin Marques <martin.marques@2ndquadrant.com>)
Список pgsql-general
Дерево обсуждения


The only thing I can think of is that there's a foreign key from foo to
bar(id), but the create index on bar shouldn't prevent a share lock on
foo, even if such a restriction exists.

--
Martín Marqués                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
No, there are no foreign keys at all in this db. It is a logical replica.

Thanks,
Jeremy 

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

Предыдущее
От: Jeremy Finzel
Дата:
Сообщение: Re: Deadlock between concurrent index builds on different tables
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: Array of foreign key