Horton

Re: [PATCH] Add sortsupport for range types and btree_gist

Heikki Linnakangas <hlinnaka@iki.fi>

View thread View on postgr.es
From: Heikki Linnakangas <hlinnaka@iki.fi>
To: Bernd Helmle <mailings@oopsware.de>, Andrey Borodin <x4mmm@yandex-team.ru>
Cc: Michael Paquier <michael@paquier.xyz>, jian he <jian.universality@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-04-03T11:13:38Z
Lists: pgsql-hackers 
On 02/04/2025 22:41, Heikki Linnakangas wrote:
> On 02/04/2025 20:18, Heikki Linnakangas wrote:
>> So I added it for the btree opfamily too, and moved the function to 
>> rangetypes.c since it's not just for gist anymore. I Ccmmitted that 
>> part, and will start looking more closely at the remaining btree_gist 
>> parts now.
> 
> Here's an updated version of the remaining parts. Found a couple of bugs:

Committed with some further cosmetic fixes. Thanks for the patience, 
this has been lingering for a long time, especially if you count the 
earlier attempt back in 2021!

-- 
Heikki Linnakangas
Neon (https://neon.tech)

Commits

  1. Add support for sorted gist index builds to btree_gist

  2. Add GiST and btree sortsupport routines for range types

  3. Change gist stratnum function to use CompareType

  4. Doc: improve documentation for jsonpath behavior.

  5. Add sortsupport for gist_btree opclasses, for faster index builds.