Horton

Add polygon opclass for SP-GiST

Teodor Sigaev <teodor@sigaev.ru>

View on postgr.es
Commit: ff963b393ca93a71d2f398c4c584b322cd351c2c
Author: Teodor Sigaev <teodor@sigaev.ru>
Date: 2017-12-25T15:59:38Z
Releases: 11.0 
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.1030506@sigaev.ru

Files

PathChange+/−
doc/src/sgml/spgist.sgml modified +36 −0
src/backend/utils/adt/geo_ops.c modified +1 −2
src/backend/utils/adt/geo_spgist.c modified +88 −4
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_amop.h modified +16 −0
src/include/catalog/pg_amproc.h modified +6 −0
src/include/catalog/pg_opclass.h modified +1 −0
src/include/catalog/pg_opfamily.h modified +1 −0
src/include/catalog/pg_proc.h modified +5 −0
src/include/utils/geo_decls.h modified +2 −1
src/test/regress/expected/polygon.out modified +238 −0
src/test/regress/expected/sanity_check.out modified +3 −0
src/test/regress/sql/polygon.sql modified +93 −0

Documentation touched

Discussion