]> granicus.if.org Git - postgresql/commit
Allow SET STATISTICS on expression indexes
authorSimon Riggs <simon@2ndQuadrant.com>
Wed, 6 Sep 2017 20:46:01 +0000 (13:46 -0700)
committerSimon Riggs <simon@2ndQuadrant.com>
Wed, 6 Sep 2017 20:46:01 +0000 (13:46 -0700)
commit5b6d13eec72b960eb0f78542199380e49c8583d4
tree8893caeb77015bb2502f3795954b6f59b5b04305
parente09db94c0a5f3b440d96c5c9e8e6c1638d1ec39f
Allow SET STATISTICS on expression indexes

Index columns are referenced by ordinal number rather than name, e.g.
CREATE INDEX coord_idx ON measured (x, y, (z + t));
ALTER INDEX coord_idx ALTER COLUMN 3 SET STATISTICS 1000;

Incompatibility note for release notes:
\d+ for indexes now also displays Stats Target

Authors: Alexander Korotkov, with contribution by Adrien NAYRAT
Review: Adrien NAYRAT, Simon Riggs
Wordsmith: Simon Riggs
13 files changed:
doc/src/sgml/ref/alter_index.sgml
src/backend/commands/tablecmds.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/parser/gram.y
src/backend/utils/cache/syscache.c
src/bin/psql/describe.c
src/bin/psql/tab-complete.c
src/include/nodes/parsenodes.h
src/include/utils/syscache.h
src/test/regress/expected/alter_table.out
src/test/regress/expected/create_index.out
src/test/regress/sql/alter_table.sql