granicus.if.org Git - postgresql/commit - doc/src/sgml/ref/create

]> granicus.if.org Git - postgresql/commit - doc/src/sgml/ref/create_table.sgml

author	Teodor Sigaev <teodor@sigaev.ru>
	Fri, 8 Apr 2016 16:31:49 +0000 (19:31 +0300)
committer	Teodor Sigaev <teodor@sigaev.ru>
	Fri, 8 Apr 2016 16:45:59 +0000 (19:45 +0300)
commit	386e3d7609c49505e079c40c65919d99feb82505
tree	dd8f434e5401588c2b4f9e2068f396c5ce198cf6	tree \| snapshot
parent	339025c68f95d3cb2c42478109cafeaf414c7fe0	commit \| diff

CREATE INDEX ... INCLUDING (column[, ...])

Now indexes (but only B-tree for now) can contain "extra" column(s) which
doesn't participate in index structure, they are just stored in leaf
tuples. It allows to use index only scan by using single index instead
of two or more indexes.

Author: Anastasia Lubennikova with minor editorializing by me
Reviewers: David Rowley, Peter Geoghegan, Jeff Janes

68 files changed:

contrib/dblink/dblink.c		diff \| blob \| history
contrib/tcn/tcn.c		diff \| blob \| history
doc/src/sgml/catalogs.sgml		diff \| blob \| history
doc/src/sgml/indexam.sgml		diff \| blob \| history
doc/src/sgml/indices.sgml		diff \| blob \| history
doc/src/sgml/ref/create_index.sgml		diff \| blob \| history
doc/src/sgml/ref/create_table.sgml		diff \| blob \| history
src/backend/access/brin/brin.c		diff \| blob \| history
src/backend/access/common/indextuple.c		diff \| blob \| history
src/backend/access/gin/ginutil.c		diff \| blob \| history
src/backend/access/gist/gist.c		diff \| blob \| history
src/backend/access/hash/hash.c		diff \| blob \| history
src/backend/access/index/genam.c		diff \| blob \| history
src/backend/access/nbtree/nbtinsert.c		diff \| blob \| history
src/backend/access/nbtree/nbtpage.c		diff \| blob \| history
src/backend/access/nbtree/nbtree.c		diff \| blob \| history
src/backend/access/nbtree/nbtsearch.c		diff \| blob \| history
src/backend/access/nbtree/nbtsort.c		diff \| blob \| history
src/backend/access/nbtree/nbtutils.c		diff \| blob \| history
src/backend/access/spgist/spgutils.c		diff \| blob \| history
src/backend/bootstrap/bootparse.y		diff \| blob \| history
src/backend/bootstrap/bootstrap.c		diff \| blob \| history
src/backend/catalog/heap.c		diff \| blob \| history
src/backend/catalog/index.c		diff \| blob \| history
src/backend/catalog/indexing.c		diff \| blob \| history
src/backend/catalog/pg_constraint.c		diff \| blob \| history
src/backend/catalog/toasting.c		diff \| blob \| history
src/backend/commands/indexcmds.c		diff \| blob \| history
src/backend/commands/matview.c		diff \| blob \| history
src/backend/commands/tablecmds.c		diff \| blob \| history
src/backend/commands/trigger.c		diff \| blob \| history
src/backend/commands/typecmds.c		diff \| blob \| history
src/backend/executor/execIndexing.c		diff \| blob \| history
src/backend/executor/nodeIndexscan.c		diff \| blob \| history
src/backend/nodes/copyfuncs.c		diff \| blob \| history
src/backend/nodes/equalfuncs.c		diff \| blob \| history
src/backend/nodes/outfuncs.c		diff \| blob \| history
src/backend/optimizer/path/indxpath.c		diff \| blob \| history
src/backend/optimizer/path/pathkeys.c		diff \| blob \| history
src/backend/optimizer/util/plancat.c		diff \| blob \| history
src/backend/parser/analyze.c		diff \| blob \| history
src/backend/parser/gram.y		diff \| blob \| history
src/backend/parser/parse_relation.c		diff \| blob \| history
src/backend/parser/parse_target.c		diff \| blob \| history
src/backend/parser/parse_utilcmd.c		diff \| blob \| history
src/backend/utils/adt/ruleutils.c		diff \| blob \| history
src/backend/utils/adt/selfuncs.c		diff \| blob \| history
src/backend/utils/cache/relcache.c		diff \| blob \| history
src/backend/utils/sort/tuplesort.c		diff \| blob \| history
src/bin/pg_dump/pg_dump.c		diff \| blob \| history
src/bin/pg_dump/pg_dump.h		diff \| blob \| history
src/include/access/amapi.h		diff \| blob \| history
src/include/access/itup.h		diff \| blob \| history
src/include/access/nbtree.h		diff \| blob \| history
src/include/catalog/catversion.h		diff \| blob \| history
src/include/catalog/pg_constraint.h		diff \| blob \| history
src/include/catalog/pg_constraint_fn.h		diff \| blob \| history
src/include/catalog/pg_index.h		diff \| blob \| history
src/include/nodes/execnodes.h		diff \| blob \| history
src/include/nodes/parsenodes.h		diff \| blob \| history
src/include/nodes/relation.h		diff \| blob \| history
src/include/utils/rel.h		diff \| blob \| history
src/test/regress/expected/create_index.out		diff \| blob \| history
src/test/regress/expected/index_including.out	[new file with mode: 0644]	blob
src/test/regress/parallel_schedule		diff \| blob \| history
src/test/regress/serial_schedule		diff \| blob \| history
src/test/regress/sql/create_index.sql		diff \| blob \| history
src/test/regress/sql/index_including.sql	[new file with mode: 0644]	blob

Unnamed repository; edit this file 'description' to name the repository.

RSS Atom