From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Allow SET STATISTICS on expression indexes |
Date: | 2017-09-06 20:48:10 |
Message-ID: | E1dphF4-0005gk-Nm@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
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
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/5b6d13eec72b960eb0f78542199380e49c8583d4
Modified Files
--------------
doc/src/sgml/ref/alter_index.sgml | 39 +++++++++++++++++++++
src/backend/commands/tablecmds.c | 55 +++++++++++++++++++++++-------
src/backend/nodes/copyfuncs.c | 1 +
src/backend/nodes/equalfuncs.c | 1 +
src/backend/parser/gram.y | 16 +++++++++
src/backend/utils/cache/syscache.c | 46 +++++++++++++++++++++++++
src/bin/psql/describe.c | 2 ++
src/bin/psql/tab-complete.c | 5 ++-
src/include/nodes/parsenodes.h | 2 ++
src/include/utils/syscache.h | 3 ++
src/test/regress/expected/alter_table.out | 24 +++++++++++++
src/test/regress/expected/create_index.out | 8 ++---
src/test/regress/sql/alter_table.sql | 16 +++++++++
13 files changed, 201 insertions(+), 17 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-09-06 21:32:45 | pgsql: Merge duplicative code for \sf/\sv, \ef/\ev in psql/command.c. |
Previous Message | Fabien COELHO | 2017-09-06 18:58:57 | Re: [COMMITTERS] pgsql: Add psql variables showing server version and psql version. |