Re: allow sorted builds for btree_gist

x4mmm@yandex-team.ru

From: "Andrey M. Borodin" <x4mmm@yandex-team.ru>
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2024-05-18T06:51:00Z
Lists: pgsql-hackers

> On 18 May 2024, at 00:41, Tomas Vondra <tomas.vondra@enterprisedb.com> wrote:
> 
> if the opclass supports sorted
> builds, because then we could parallelize the sort.

Hi Tomas!

Yup, I'd also be glad to see this feature. PostGIS folks are using their geometry (sortsupport was developed for this) with object id (this disables sort build).

It was committed once [0], but then reverted, vardata opclasses were implemented wrong. Now it's on CF[1], Bernd is actively responding in the thread, but currently patch lacks tests.

Thanks for raising this!


Best regards, Andrey Borodin.

[0] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=9f984ba6d23dc
[1] https://commitfest.postgresql.org/48/3686/