Re: allow sorted builds for btree_gist

2024-06-03 Thread Bernd Helmle
Hi, Am Samstag, dem 18.05.2024 um 12:22 +0200 schrieb Tomas Vondra: > > 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 raisin

Re: allow sorted builds for btree_gist

2024-05-18 Thread Michał Kłeczek
> On 17 May 2024, at 21:41, Tomas Vondra 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

Re: allow sorted builds for btree_gist

2024-05-18 Thread Tomas Vondra
On 5/18/24 02:00, Paul A Jungwirth wrote: > On Fri, May 17, 2024 at 12:41 PM Tomas Vondra > wrote: >> 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. >

Re: allow sorted builds for btree_gist

2024-05-18 Thread Andrey M. Borodin
> On 18 May 2024, at 15:22, Tomas Vondra wrote: > > Let's continue working on that patch/thread, I'll take a look in the > next CF. Cool! I'd be happy to review the patch before CF when Bernd or Christoph will address current issues. Best regards, Andrey Borodin.

Re: allow sorted builds for btree_gist

2024-05-18 Thread Tomas Vondra
On 5/18/24 08:51, Andrey M. Borodin wrote: > > >> On 18 May 2024, at 00:41, Tomas Vondra >> 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 geomet

Re: allow sorted builds for btree_gist

2024-05-17 Thread Andrey M. Borodin
> On 18 May 2024, at 00:41, Tomas Vondra 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 disa

Re: allow sorted builds for btree_gist

2024-05-17 Thread Paul A Jungwirth
On Fri, May 17, 2024 at 12:41 PM Tomas Vondra wrote: > 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 f

allow sorted builds for btree_gist

2024-05-17 Thread Tomas Vondra
ST - it would help only with a small part of cases, I think. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL CompanyFrom 011e6eee923a6f51668f3277f470d32922923d17 Mon Sep 17 00:00:00 2001 From: Tomas Vondra Date: Fri, 17 May 2024 20:36:08 +0200 Subject: [PATCH