Re: optimize lookups in snapshot [sub]xip arrays

Поиск
Список
Период
Сортировка
От Nathan Bossart
Тема Re: optimize lookups in snapshot [sub]xip arrays
Дата
Msg-id 20220725040856.GB4085281@nathanxps13
обсуждение исходный текст
Ответ на Re: optimize lookups in snapshot [sub]xip arrays  (Zhang Mingli <zmlpostgres@gmail.com>)
Ответы Re: optimize lookups in snapshot [sub]xip arrays  (Zhang Mingli <zmlpostgres@gmail.com>)
Список pgsql-hackers
On Sun, Jul 24, 2022 at 12:48:25PM +0800, Zhang Mingli wrote:
> If snaphost->suboverflowed is  false then the subxcnt must be less than PGPROC_MAX_CACHED_SUBXIDS which is 64 now.
> 
> And we won’t use hash if the xcnt is less than XIP_HASH_MIN_ELEMENTS which is 128 currently during discussion.
> 
> So that, subxid’s hash table will never be used, right?

This array will store up to TOTAL_MAX_CACHED_SUBXIDS transactions, which
will typically be much greater than 64.  When there isn't any overflow,
subxip stores all of the subxids for all of the entries in the procarray.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com



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

Предыдущее
От: Richard Guo
Дата:
Сообщение: Re: ReadRecentBuffer() is broken for local buffer
Следующее
От: jian he
Дата:
Сообщение: COPY FROM FORMAT CSV FORCE_NULL(*) ?