Horton

Support INCLUDE'd columns in SP-GiST.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 09c1c6ab4bc5764dd69c53ccfd43b2060b1fd090
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2021-04-05T22:41:21Z
Releases: 14.0 
Support INCLUDE'd columns in SP-GiST.

Not much to say here: does what it says on the tin.
We steal a previously-always-zero bit from the nextOffset
field of leaf index tuples in order to track whether there
is a nulls bitmap.  Otherwise it works about like included
columns in other index types.

Pavel Borisov, reviewed by Andrey Borodin and Anastasia Lubennikova,
and rather heavily editorialized on by me

Discussion: https://postgr.es/m/CALT9ZEFi-vMp4faht9f9Junb1nO3NOSjhpxTmbm1UGLMsLqiEQ@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/indices.sgml modified +7 −5
doc/src/sgml/ref/create_index.sgml modified +6 −3
doc/src/sgml/spgist.sgml modified +8 −0
doc/src/sgml/xindex.sgml modified +6 −2
src/backend/access/common/indextuple.c modified +24 −9
src/backend/access/spgist/README modified +15 −3
src/backend/access/spgist/spgdoinsert.c modified +86 −48
src/backend/access/spgist/spginsert.c modified +2 −2
src/backend/access/spgist/spgscan.c modified +65 −27
src/backend/access/spgist/spgutils.c modified +232 −52
src/backend/access/spgist/spgvacuum.c modified +10 −10
src/backend/access/spgist/spgxlog.c modified +3 −3
src/include/access/itup.h modified +3 −0
src/include/access/spgist_private.h modified +66 −18
src/test/modules/spgist_name_ops/expected/spgist_name_ops.out modified +46 −39
src/test/modules/spgist_name_ops/sql/spgist_name_ops.sql modified +11 −8
src/test/regress/expected/amutils.out modified +1 −1
src/test/regress/expected/create_index_spgist.out modified +29 −0
src/test/regress/expected/index_including.out modified +1 −2
src/test/regress/sql/create_index_spgist.sql modified +9 −0
src/test/regress/sql/index_including.sql modified +1 −1

Documentation touched

Discussion