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

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: "sergei sh(dot)" <sshoulbakov(at)kontur(dot)io>
Cc: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: [PATCH] reduce page overlap of GiST indexes built using sorted method
Date: 2022-02-04 00:52:56
Message-ID: CAPpHfdsBFanR_Aez6Srgm+AqASy979M6tJL-CFy-qHRwiMkjBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

On Wed, Jan 26, 2022 at 7:07 PM sergei sh. <sshoulbakov(at)kontur(dot)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

Attachment Content-Type Size
0001-Reduce-non-leaf-keys-overlap-in-GiST-indexes-prod-v5.patch application/octet-stream 17.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2022-02-04 01:35:39 Re: do only critical work during single-user vacuum?
Previous Message Robert Haas 2022-02-04 00:47:57 Re: Fix BUG #17335: Duplicate result rows in Gather node