Horton

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

Bernd Helmle <mailings@oopsware.de>

View thread View on postgr.es
From: Bernd Helmle <mailings@oopsware.de>
To: "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Cc: jian he <jian.universality@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2024-10-25T16:41:39Z
Lists: pgsql-hackers

Attachments

Am Freitag, dem 22.03.2024 um 15:20 +0100 schrieb Bernd Helmle:
> > FWIW it would be nice at least port tests from commit that I
> > referenced upthread.
> > Nowadays we have injection points, so these tests can be much more
> > stable.
> 
> Alright, that's a reasonable point. I will look into this. Did you
> see
> other important things missing?
> 
> Changed status back to "Waiting On Author".

So this is a new rebased version of the patches including regression
tests with default (sortsupport) and buffering behavior. I split up the
tests for buffering vs. non-buffering but kept them basically the same
for testing the index builts.

I've registered this patch in the upcoming commitfest again for another
review round 

Thanks
	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.