Re: Use generation context to speed up tuplesorts

Поиск
Список
Период
Сортировка
От Ronan Dunklau
Тема Re: Use generation context to speed up tuplesorts
Дата
Msg-id 36444569.XM6RcZxFsP@aivenronan
обсуждение исходный текст
Ответ на Re: Use generation context to speed up tuplesorts  (Ronan Dunklau <ronan.dunklau@aiven.io>)
Ответы Re: Use generation context to speed up tuplesorts  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Список pgsql-hackers
Le jeudi 16 décembre 2021, 11:56:15 CET Ronan Dunklau a écrit :
> I will follow up with a benchmark of the test sorting a table with a width
> varying from 1 to 32 columns.
>

So please find attached another benchmark for that case.

The 3 different patchsets tested are:

 - master
 - fixed (David's original patch)
 - adjust (Thomas growing blocks patch)

So it looks like tuning malloc for this would be very benificial for any kind
of allocation, and by doing so we reduce the problems seen with the growing
blocks patch to next to nothing, while keeping the ability to not allocate too
much memory from the get go.

I would like to try to implement some dynamic glibc malloc tuning, if that is
something we don't reject on principle from the get go.


--
Ronan Dunklau
Вложения

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Buildfarm support for older versions
Следующее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: [PATCH] Document heuristics for parameterized paths