Re: Slow standby snapshot

Поиск
Список
Период
Сортировка
От Kyotaro Horiguchi
Тема Re: Slow standby snapshot
Дата
Msg-id 20220727.160807.1746105134891096510.horikyota.ntt@gmail.com
обсуждение исходный текст
Ответ на Re: Slow standby snapshot  (Andrey Borodin <x4mmm@yandex-team.ru>)
Ответы Re: Slow standby snapshot  (Simon Riggs <simon.riggs@enterprisedb.com>)
Список pgsql-hackers
At Tue, 26 Jul 2022 23:09:16 +0500, Andrey Borodin <x4mmm@yandex-team.ru> wrote in 
> 
> 
> > On 20 Jul 2022, at 02:12, Michail Nikolaev <michail.nikolaev@gmail.com> wrote:
> > 
> >> I've looked into v5.
> > Thanks!
> > 
> > Patch is updated accordingly your remarks.
> 
> The patch seems Ready for Committer from my POV.

+ * is s updated during taking the snapshot. The KnownAssignedXidsNextOffset
+ * contains not an offset to the next valid xid but a number which tends to
+ * the offset to next valid xid. KnownAssignedXidsNextOffset[] values read

Is there still a reason why the array stores the distnace to the next
valid element instead of the index number of the next valid index?  It
seems to me that that was in an intention to reduce the size of the
offset array but it is int32[] which is far wider than
TOTAL_MAX_CACHED_SUBXIDS.

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

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Cygwin cleanup
Следующее
От: Matthias van de Meent
Дата:
Сообщение: Re: Improving btree performance through specializing by key shape, take 2