Re: range_agg

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Jeff Davis <pgsql(at)j-davis(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, David Fetter <david(at)fetter(dot)org>
Subject: Re: range_agg
Date: 2020-12-27 09:50:07
Message-ID: CAPpHfdvfOqDWWJgq96QatPbhqZLtbpEKY_+X8nAi_-2S76H3mA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Dec 17, 2020 at 10:10 PM Alexander Korotkov
<aekorotkov(at)gmail(dot)com> wrote:
>
> I think this patch is very close to committable. I'm going to spend
> some more time further polishing it and commit (if I don't find a
> major issue or face objections).

The main patch is committed. I've prepared a set of improvements.
0001 Fixes bug in bsearch comparison functions
0002 Implements missing @> (range,multirange) operator and its commutator
0003 Does refactors signatures of *_internal() multirange functions
0004 Adds cross-type (range, multirange) operators handling to
existing range GiST opclass
0005 Adds support for GiST multirange indexing by approximation of
multirange as the union range with no gaps

The patchset is quite trivial. I'm going to push it if there are no objections.

The SP-GiST handling is more tricky and requires substantial work.

------
Regards,
Alexander Korotkov

Attachment Content-Type Size
0001-Fix-bugs-in-comparison-functions-for-multirange_bsea.patch application/octet-stream 3.4 KB
0002-Implement-operators-for-checking-if-the-range-contai.patch application/octet-stream 15.8 KB
0003-Improve-the-signature-of-internal-multirange-functio.patch application/octet-stream 23.4 KB
0005-Add-GiST-indexes-for-multiranges.patch application/octet-stream 26.4 KB
0004-Add-support-of-multirange-matching-to-the-existing-r.patch application/octet-stream 26.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2020-12-27 13:14:53 Re: Add table access method as an option to pgbench
Previous Message Bharath Rupireddy 2020-12-27 08:57:54 Re: Parallel Inserts in CREATE TABLE AS