Re: Use generation context to speed up tuplesorts

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Use generation context to speed up tuplesorts
Дата
Msg-id CAApHDvqbEvhiw3DqxN-J_2YNYZ-TNeyCXcvURX1A68Lse3Gp3A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Use generation context to speed up tuplesorts  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Ответы Re: Use generation context to speed up tuplesorts  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Список pgsql-hackers
On Sat, 7 Aug 2021 at 12:10, Tomas Vondra <tomas.vondra@enterprisedb.com> wrote:
> > All of the tests show that the patches to improve the allocation
> > efficiency of generation.c don't help to improve the results of the
> > test cases. I wondered if it's maybe worth trying to see what happens
> > if instead of doubling the allocations each time, quadruple them
> > instead. I didn't try this.
> >
>
> I doubt quadrupling the allocations won't help very much, but I suspect
> the problem might be in the 0004 patch - at least that's what shows
> regression in my results. Could you try with just 0001-0003 applied?

I tried the quadrupling of the buffer instead of doubling it each time
and got the attached.  Column E, or green in the graphs show the
results of that. It's now much closer to the original patch which just
made the block size 8MB.

David

Вложения

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

Предыдущее
От: vignesh C
Дата:
Сообщение: Re: [PATCH]Comment improvement in publication.sql
Следующее
От: "tanghy.fnst@fujitsu.com"
Дата:
Сообщение: RE: [PATCH] Add tab-complete for backslash commands