Re: Avoiding deadlock errors in CREATE INDEX CONCURRENTLY

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Avoiding deadlock errors in CREATE INDEX CONCURRENTLY
Дата
Msg-id 804334B1-C93F-40E0-99AA-B21EEC05B556@anarazel.de
обсуждение исходный текст
Ответ на Re: Avoiding deadlock errors in CREATE INDEX CONCURRENTLY  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Avoiding deadlock errors in CREATE INDEX CONCURRENTLY  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения 
Hi,

On June 9, 2019 8:36:37 AM PDT, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>"Goel, Dhruv" <goeldhru@amazon.com> writes:
>I think you are mistaken that doing transactional updates in pg_index
>is OK.  If memory serves, we rely on xmin of the pg_index row for
>purposes
>such as detecting whether a concurrently-created index is safe to use
>yet.

We could replace that with storing a 64 xid in a normal column nowadays.

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Avoiding deadlock errors in CREATE INDEX CONCURRENTLY
Следующее
От: Avinash Kumar
Дата:
Сообщение: Re: Bloom Indexes - bit array length and the total number of bits (orhash functions ?? ) !