Add optional compression method to SP-GiST

Enterprise / PostgreSQL - Teodor Sigaev [sigaev.ru] - 22 December 2017 10:33 EST

Patch allows to have different types of column and value stored in leaf tuples of SP-GiST. The main application of feature is to transform complex column type to simple indexed type or for truncating too long value, transformation could be lossy. Simple example: polygons are converted to their bounding boxes, this opclass follows.

Authors: me, Heikki Linnakangas, Alexander Korotkov, Nikita Glukhov

854823fa33 Add optional compression method to SP-GiST
doc/src/sgml/spgist.sgml | 92 ++++++++++++++++++++++++++-------
src/backend/access/spgist/spgdoinsert.c | 37 ++++++++++---
src/backend/access/spgist/spgscan.c | 6 +--
src/backend/access/spgist/spgutils.c | 21 +++++++-
src/backend/access/spgist/spgvalidate.c | 50 +++++++++++++++++-
src/include/access/spgist.h | 5 +-
src/include/access/spgist_private.h | 8 +--
7 files changed, 182 insertions(+), 37 deletions(-)

Upstream: git.postgresql.org


  • Share