Re: [PATCH 0/3] Introduce spgist quadtree @<(point,circle) operator - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: [PATCH 0/3] Introduce spgist quadtree @<(point,circle) operator
Date
Msg-id CAPpHfduM+qsZ=uX40rXQP5HJSdrJnFmGNEeuOEKZuoVQ_ARnqw@mail.gmail.com
Whole thread Raw
In response to [PATCH 0/3] Introduce spgist quadtree @<(point,circle) operator  ("Matwey V. Kornilov" <matwey.kornilov@gmail.com>)
Responses Re: [PATCH 0/3] Introduce spgist quadtree @<(point,circle) operator
List pgsql-hackers
Hi!

On Fri, Feb 1, 2019 at 7:08 PM Matwey V. Kornilov
<matwey.kornilov@gmail.com> wrote:
> This patch series is to add support for spgist quadtree @<(point,circle)
> operator. The first two patches are to refactor existing code before
> implemention the new feature. The third commit is the actual implementation
> provided with a set of simple unit tests.

Cool!

> Matwey V. Kornilov (3):
>   Introduce helper variable in spgquadtreeproc.c
>   Introduce spg_quad_inner_consistent_box_helper() in spgquadtreeproc.c
>   Add initial support for spgist quadtree @<(point,circle) operator

At first, I have to note that it's not necessary to post every patch
in separate message.  It would be both easier and comfortable for
readers if you just put your patches as multiple attachments to the
same email message.

Regarding the patchset itself
 * spg_quad_inner_consistent_circle_helper() definitely needs comments.
 * In PostgreSQL we require that index scan produce exactly same
results as sequence scan.  Can we ensure this is so for
@<(point,circle) operator even in corner cases of rounding error?
 * In our coding style we have function name is the separate line from
its return type.

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: RE: Timeout parameters
Next
From: Michael Paquier
Date:
Subject: Re: pg_partition_tree crashes for a non-defined relation