git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

summary | shortlog | log | commit | commitdiff | tree
(parent: 339025c) | patch

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

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

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 | blame | history

contrib/tcn/tcn.c diff | blob | blame | history

doc/src/sgml/catalogs.sgml diff | blob | blame | history

doc/src/sgml/indexam.sgml diff | blob | blame | history

doc/src/sgml/indices.sgml diff | blob | blame | history

doc/src/sgml/ref/create_index.sgml diff | blob | blame | history

doc/src/sgml/ref/create_table.sgml diff | blob | blame | history

src/backend/access/brin/brin.c diff | blob | blame | history

src/backend/access/common/indextuple.c diff | blob | blame | history

src/backend/access/gin/ginutil.c diff | blob | blame | history

src/backend/access/gist/gist.c diff | blob | blame | history

src/backend/access/hash/hash.c diff | blob | blame | history

src/backend/access/index/genam.c diff | blob | blame | history

src/backend/access/nbtree/nbtinsert.c diff | blob | blame | history

src/backend/access/nbtree/nbtpage.c diff | blob | blame | history

src/backend/access/nbtree/nbtree.c diff | blob | blame | history

src/backend/access/nbtree/nbtsearch.c diff | blob | blame | history

src/backend/access/nbtree/nbtsort.c diff | blob | blame | history

src/backend/access/nbtree/nbtutils.c diff | blob | blame | history

src/backend/access/spgist/spgutils.c diff | blob | blame | history

src/backend/bootstrap/bootparse.y diff | blob | blame | history

src/backend/bootstrap/bootstrap.c diff | blob | blame | history

src/backend/catalog/heap.c diff | blob | blame | history

src/backend/catalog/index.c diff | blob | blame | history

src/backend/catalog/indexing.c diff | blob | blame | history

src/backend/catalog/pg_constraint.c diff | blob | blame | history

src/backend/catalog/toasting.c diff | blob | blame | history

src/backend/commands/indexcmds.c diff | blob | blame | history

src/backend/commands/matview.c diff | blob | blame | history

src/backend/commands/tablecmds.c diff | blob | blame | history

src/backend/commands/trigger.c diff | blob | blame | history

src/backend/commands/typecmds.c diff | blob | blame | history

src/backend/executor/execIndexing.c diff | blob | blame | history

src/backend/executor/nodeIndexscan.c diff | blob | blame | history

src/backend/nodes/copyfuncs.c diff | blob | blame | history

src/backend/nodes/equalfuncs.c diff | blob | blame | history

src/backend/nodes/outfuncs.c diff | blob | blame | history

src/backend/optimizer/path/indxpath.c diff | blob | blame | history

src/backend/optimizer/path/pathkeys.c diff | blob | blame | history

src/backend/optimizer/util/plancat.c diff | blob | blame | history

src/backend/parser/analyze.c diff | blob | blame | history

src/backend/parser/gram.y diff | blob | blame | history

src/backend/parser/parse_relation.c diff | blob | blame | history

src/backend/parser/parse_target.c diff | blob | blame | history

src/backend/parser/parse_utilcmd.c diff | blob | blame | history

src/backend/utils/adt/ruleutils.c diff | blob | blame | history

src/backend/utils/adt/selfuncs.c diff | blob | blame | history

src/backend/utils/cache/relcache.c diff | blob | blame | history

src/backend/utils/sort/tuplesort.c diff | blob | blame | history

src/bin/pg_dump/pg_dump.c diff | blob | blame | history

src/bin/pg_dump/pg_dump.h diff | blob | blame | history

src/include/access/amapi.h diff | blob | blame | history

src/include/access/itup.h diff | blob | blame | history

src/include/access/nbtree.h diff | blob | blame | history

src/include/catalog/catversion.h diff | blob | blame | history

src/include/catalog/pg_constraint.h diff | blob | blame | history

src/include/catalog/pg_constraint_fn.h diff | blob | blame | history

src/include/catalog/pg_index.h diff | blob | blame | history

src/include/nodes/execnodes.h diff | blob | blame | history

src/include/nodes/parsenodes.h diff | blob | blame | history

src/include/nodes/relation.h diff | blob | blame | history

src/include/utils/rel.h diff | blob | blame | history

src/test/regress/expected/create_index.out diff | blob | blame | history

src/test/regress/expected/index_including.out [new file with mode: 0644] blob

src/test/regress/parallel_schedule diff | blob | blame | history

src/test/regress/serial_schedule diff | blob | blame | history

src/test/regress/sql/create_index.sql diff | blob | blame | history

src/test/regress/sql/index_including.sql [new file with mode: 0644] blob

This is the main PostgreSQL git repository.