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

Bernd Helmle <mailings@oopsware.de>

From: Bernd Helmle <mailings@oopsware.de>
To: "Andrey M. 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-01-16T14:14:25Z
Lists: pgsql-hackers

Attachments

Am Mittwoch, dem 15.01.2025 um 19:24 +0100 schrieb Bernd Helmle:
> > Commit 630f9a43cece93cb4a5c243b30e34abce6a89514 created a conflict
> > with
> > this patch so that it doesn't apply anymore.
> 
> Seems i broke something during rebase (see cfbot). I will look at
> this tomorrow.

This was related to 630f9a43cec and fixed by Peter already in
d5221c49a30, so unrelated to my rebase of this patch. 

I attach a new rebased version to master anyways, which fixes an
unnecessary whitespace in the patch, no other changes.

I am going to reflag this patch as "Ready For Committer" again.

	Bernd

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.