Re: Should the nbtree page split REDO routine's locking work more like the locking on the primary?

Поиск
Список
Период
Сортировка
От Andrey M. Borodin
Тема Re: Should the nbtree page split REDO routine's locking work more like the locking on the primary?
Дата
Msg-id 1EB83B5A-B243-4278-AE8F-5F8C4DB9B15F@yandex-team.ru
обсуждение исходный текст
Ответ на Re: Should the nbtree page split REDO routine's locking work more like the locking on the primary?  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers

> 8 авг. 2020 г., в 03:28, Peter Geoghegan <pg@bowt.ie> написал(а):
>
> On Thu, Aug 6, 2020 at 7:00 PM Peter Geoghegan <pg@bowt.ie> wrote:
>> On Thu, Aug 6, 2020 at 6:08 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> +1 for making this more like what happens in original execution ("on the
>>> primary", to use your wording).  Perhaps what you suggest here is still
>>> not enough like the original execution, but it sounds closer.
>>
>> It won't be the same as the original execution, exactly -- I am only
>> thinking of holding on to same-level page locks (the original page,
>> its new right sibling, and the original right sibling).
>
> I pushed a commit that reorders the lock acquisitions within
> btree_xlog_unlink_page() -- they're now consistent with _bt_split()
> (at least among sibling pages involved in the page split).

Sounds great, thanks!

Best regards, Andrey Borodin.


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: get rid of distprep?
Следующее
От: "Andrey M. Borodin"
Дата:
Сообщение: Re: [PATCH] Covering SPGiST index