Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 15.0 \(3693.60.0.1.1\))
Subject: Re: [PATCH] Add sortsupport for range types and btree_gist
From: Andrey Borodin <x4mmm@yandex-team.ru>
In-Reply-To: <437ccbcf-8f80-2919-411d-a3af88becf6c@cybertec.at>
Date: Wed, 15 Jun 2022 19:39:34 +0500
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
 =?utf-8?B?SGFucy1Kw7xyZ2VuIFNjaMO2bmln?= <hs@cybertec.at>
Content-Transfer-Encoding: quoted-printable
Message-Id: <96CDC1AB-53AC-4543-A139-ED7C61F17B5A@yandex-team.ru>
References: <437ccbcf-8f80-2919-411d-a3af88becf6c@cybertec.at>
To: Christoph Heiss <christoph.heiss@cybertec.at>
Archived-At: 
 <https://www.postgresql.org/message-id/96CDC1AB-53AC-4543-A139-ED7C61F17B5A%40yandex-team.ru>
Precedence: bulk

Hi Christoph!

> On 15 Jun 2022, at 15:45, Christoph Heiss =
<christoph.heiss@cybertec.at> wrote:
>=20
> By sorting the data before inserting it into the index results in a =
much better index structure, leading to significant performance =
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/=