Re: allow sorted builds for btree_gist - Mailing list pgsql-hackers

From Michał Kłeczek
Subject Re: allow sorted builds for btree_gist
Date
Msg-id 1CF6E107-AFC9-4D28-BA2E-CE29B7C40E3C@kleczek.org
Whole thread Raw
In response to allow sorted builds for btree_gist  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
List pgsql-hackers

> On 17 May 2024, at 21:41, Tomas Vondra <tomas.vondra@enterprisedb.com> wrote:
>
> Hi,
>
> I've been looking at GiST to see if there could be a good way to do
> parallel builds - and there might be, if the opclass supports sorted
> builds, because then we could parallelize the sort.
>
> But then I noticed we support this mode only for point_ops, because
> that's the only opclass with sortsupport procedure. Which mostly makes
> sense, because types like geometries, polygons, ... do not have a well
> defined order.
>
> Still, we have btree_gist, and I don't think there's much reason to not
> support sorted builds for those opclasses, where the gist opclass is
> defined on top of btree ordering semantics.
>


I wonder if it was possible to add sort support to pg_trgm. Speeding up index build for multicolumn indexes supporting
textsearch would be great. 

—
Michal




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Speed up clean meson builds by ~25%
Next
From: "Andrey M. Borodin"
Date:
Subject: Sort functions with specialized comparators