Re: [PATCH] reduce page overlap of GiST indexes built using sorted method

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: [PATCH] reduce page overlap of GiST indexes built using sorted method
Дата
Msg-id CAPpHfdsBFanR_Aez6Srgm+AqASy979M6tJL-CFy-qHRwiMkjBg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] reduce page overlap of GiST indexes built using sorted method  ("sergei sh." <sshoulbakov@kontur.io>)
Ответы Re: [PATCH] reduce page overlap of GiST indexes built using sorted method
Список pgsql-hackers
Hi!

On Wed, Jan 26, 2022 at 7:07 PM sergei sh. <sshoulbakov@kontur.io> wrote:
> I've fixed issues 2 -- 4 in attached version.
>
> GUC parameter has been removed for the number of pages to collect
> before splitting and fixed value of 4 is used instead, as discussed
> off-list with Andrey Borodin, Aliaksandr Kalenik, Darafei
> Praliaskouski. Benchmarking shows that using higher values has almost
> no effect on query efficiency while increasing index building time.
>
> PSA graphs for index creation and query time, "tiling" and "self-join"
> refer to queries used in previous benchmarks:
> https://github.com/mngr777/pg_index_bm2
>
> Sorted build method description has been added in GiST README.

Thank you for the revision.  This patch looks good to me.  I've
slightly adjusted comments and formatting and wrote the commit
message.

I'm going to push this if no objections.

------
Regards,
Alexander Korotkov

Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Fix BUG #17335: Duplicate result rows in Gather node
Следующее
От: Andres Freund
Дата:
Сообщение: Re: do only critical work during single-user vacuum?