Re: bt_index_parent_check and concurrently build indexes - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Re: bt_index_parent_check and concurrently build indexes
Date
Msg-id 50011793-9DA8-405E-8E17-128DA8B10CA2@yandex-team.ru
Whole thread Raw
List 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 by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
Next
From: "Andrey M. Borodin"
Date:
Subject: Re: Fix bank selection logic in SLRU