Re: [PATCH] Add sortsupport for range types and btree_gist - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: [PATCH] Add sortsupport for range types and btree_gist
Date
Msg-id 96CDC1AB-53AC-4543-A139-ED7C61F17B5A@yandex-team.ru
Whole thread Raw
In response to [PATCH] Add sortsupport for range types and btree_gist  (Christoph Heiss <christoph.heiss@cybertec.at>)
Responses Re: [PATCH] Add sortsupport for range types and btree_gist  (Jacob Champion <jchampion@timescale.com>)
List pgsql-hackers
Hi Christoph!

> On 15 Jun 2022, at 15:45, Christoph Heiss <christoph.heiss@cybertec.at> wrote:
>
> By sorting the data before inserting it into the index results in a much better index structure, leading to
significantperformance improvements. 

Here's my version of the very similar idea [0]. It lacks range types support.
On a quick glance your version lacks support of abbreviated sort, so I think benchmarks can be pushed event further :)
Let's merge our efforts and create combined patch?

Please, create a new entry for the patch on Commitfest.

Thank you!

Best regards, Andrey Borodin.

[0] https://commitfest.postgresql.org/37/2824/


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: replacing role-level NOINHERIT with a grant-level option
Next
From: Aleksander Alekseev
Date:
Subject: Re: CREATE TABLE ( .. STORAGE ..)