Re: Prefetch the next tuple's memory during seqscans

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Prefetch the next tuple's memory during seqscans
Дата
Msg-id CAApHDvqcGsGrm6HQzFFFK7_XX2T3Q+q++u+c0yNncGLsHb8H+w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Prefetch the next tuple's memory during seqscans  (sirisha chamarthi <sirichamarthi22@gmail.com>)
Список pgsql-hackers
On Wed, 23 Nov 2022 at 21:26, sirisha chamarthi
<sirichamarthi22@gmail.com> wrote:
> Master
> After vacuum:
> latency average = 393.880 ms
>
> Master + 0001 + 0005
> After vacuum:
> latency average = 369.591 ms

Thank you for running those again.  Those results make more sense.
Would you mind also testing the count(*) query too?

David



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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Hash index build performance tweak from sorting
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Hash index build performance tweak from sorting