]> granicus.if.org Git - postgresql/commit
Support for INCLUDE attributes in GiST indexes
authorAlexander Korotkov <akorotkov@postgresql.org>
Sun, 10 Mar 2019 08:36:47 +0000 (11:36 +0300)
committerAlexander Korotkov <akorotkov@postgresql.org>
Sun, 10 Mar 2019 08:37:17 +0000 (11:37 +0300)
commitf2e403803fe6deb8cff59ea09dff42c6163b2110
tree1c3afef6e11f6498002b88219d9644e71bb5972d
parenta0b762626884b3b949c2703abb1c4b42fbbdfdc6
Support for INCLUDE attributes in GiST indexes

Similarly to B-tree, GiST index access method gets support of INCLUDE
attributes.  These attributes aren't used for tree navigation and aren't
present in non-leaf pages.  But they are present in leaf pages and can be
fetched during index-only scan.

The point of having INCLUDE attributes in GiST indexes is slightly different
from the point of having them in B-tree.  The main point of INCLUDE attributes
in B-tree is to define UNIQUE constraint over part of attributes enabled for
index-only scan.  In GiST the main point of INCLUDE attributes is to use
index-only scan for attributes, whose data types don't have GiST opclasses.

Discussion: https://postgr.es/m/73A1A452-AD5F-40D4-BD61-978622FF75C1%40yandex-team.ru
Author: Andrey Borodin, with small changes by me
Reviewed-by: Andreas Karlsson
16 files changed:
doc/src/sgml/indices.sgml
doc/src/sgml/ref/create_index.sgml
doc/src/sgml/textsearch.sgml
src/backend/access/gist/gist.c
src/backend/access/gist/gistget.c
src/backend/access/gist/gistscan.c
src/backend/access/gist/gistsplit.c
src/backend/access/gist/gistutil.c
src/include/access/gist_private.h
src/test/regress/expected/amutils.out
src/test/regress/expected/index_including.out
src/test/regress/expected/index_including_gist.out [new file with mode: 0644]
src/test/regress/parallel_schedule
src/test/regress/serial_schedule
src/test/regress/sql/index_including.sql
src/test/regress/sql/index_including_gist.sql [new file with mode: 0644]