Re: bt_index_parent_check and concurrently build indexes

Поиск
Список
Период
Сортировка
От Andrey M. Borodin
Тема Re: bt_index_parent_check and concurrently build indexes
Дата
Msg-id 50011793-9DA8-405E-8E17-128DA8B10CA2@yandex-team.ru
обсуждение исходный текст
Список pgsql-hackers

> On 9 Dec 2024, at 23:51, Michail Nikolaev <michail.nikolaev@gmail.com> wrote:
>
> * Modify bt_index_parent_check to use an MVCC snapshot for the heap scan

Hi!

Interesting bug. It's amazing how long it stand, giving that it would be triggered by almost any check after updating a
table.

From my POV correct fix direction is to use approach similar to index building.
E.i. remove "if (!state->readonly)" check. Are there any known downsides of this?


Best regards, Andrey Borodin.


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