Re: Slow standby snapshot

Поиск
Список
Период
Сортировка
От Michail Nikolaev
Тема Re: Slow standby snapshot
Дата
Msg-id CANtu0ohiyvGNOohEWFo98ySBtifj=yo9JBLd==HkLPrA-ff+PQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow standby snapshot  (Simon Riggs <simon.riggs@enterprisedb.com>)
Ответы Re: Slow standby snapshot  (Simon Riggs <simon.riggs@enterprisedb.com>)
Список pgsql-hackers
Hello.

Thanks to everyone for the review.

> It seems to me storing the index itself is simpler and maybe faster by
> the cycles to perform addition.

Yes, first version used 1-byte for offset with maximum value of 255.
Agreed, looks like there is no sense to store offsets now.

> A simple patch like this seems to hit the main concern, aiming to keep
> the array from spreading out and impacting snapshot performance for
> SELECTs, yet not doing it so often that the startup process has a
> higher burden of work.

Nice, I'll do performance testing for both versions and master branch
as baseline.

Thanks,
Michail.



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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: [Commitfest 2022-07] Patch Triage: Needs Review, Part 1
Следующее
От: Robert Haas
Дата:
Сообщение: Re: making relfilenodes 56 bits