pgsql: Add polygon opclass for SP-GiST

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add polygon opclass for SP-GiST
Date: 2017-12-25 16:00:26
Message-ID: E1eTVAw-0000Bh-Ap@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add polygon opclass for SP-GiST

Polygon opclass uses compress method feature of SP-GiST added earlier. For now
it's a single operator class which uses this feature. SP-GiST actually indexes
a bounding boxes of input polygons, so part of supported operations are lossy.
Opclass uses most methods of corresponding opclass over boxes of SP-GiST and
treats bounding boxes as point in 4D-space.

Bump catalog version.

Authors: Nikita Glukhov, Alexander Korotkov with minor editorization by me
Reviewed-By: all authors + Darafei Praliaskouski
Discussion: https://www.postgresql.org/message-id/flat/54907069(dot)1030506(at)sigaev(dot)ru

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ff963b393ca93a71d2f398c4c584b322cd351c2c

Modified Files
--------------
doc/src/sgml/spgist.sgml | 36 +++++
src/backend/utils/adt/geo_ops.c | 3 +-
src/backend/utils/adt/geo_spgist.c | 92 ++++++++++-
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_amop.h | 16 ++
src/include/catalog/pg_amproc.h | 6 +
src/include/catalog/pg_opclass.h | 1 +
src/include/catalog/pg_opfamily.h | 1 +
src/include/catalog/pg_proc.h | 5 +
src/include/utils/geo_decls.h | 3 +-
src/test/regress/expected/polygon.out | 238 +++++++++++++++++++++++++++++
src/test/regress/expected/sanity_check.out | 3 +
src/test/regress/sql/polygon.sql | 93 +++++++++++
13 files changed, 491 insertions(+), 8 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Thomas Munro 2017-12-26 10:48:37 Re: pgsql: Add parallel-aware hash joins.
Previous Message Andres Freund 2017-12-24 11:02:11 pgsql: Fix assert with side effects in the new PHJ code.