Re: Hash index build performance tweak from sorting

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Hash index build performance tweak from sorting
Дата
Msg-id CAApHDvqpKpqLufiR8pBdb8ZugENun7Q-j7dd0a23bUrpSHTvnw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Hash index build performance tweak from sorting  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Ответы Re: Hash index build performance tweak from sorting  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Список pgsql-hackers
On Fri, 18 Nov 2022 at 03:34, Tomas Vondra
<tomas.vondra@enterprisedb.com> wrote:
> I did some simple benchmark with v2 and v3, using the attached script,
> which essentially just builds hash index on random data, with different
> data types and maintenance_work_mem values. And what I see is this
> (median of 10 runs):

> So to me it seems v2 performs demonstrably better, v3 is consistently
> slower - not only compared to v2, but often also to master.

Could this just be down to code alignment changes?  There does not
really seem to be any fundamental differences which would explain
this.

David



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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Hash index build performance tweak from sorting
Следующее
От: David Rowley
Дата:
Сообщение: Re: Prefetch the next tuple's memory during seqscans