From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Cleanup covering infrastructure |
Date: | 2018-04-12 13:38:11 |
Message-ID: | E1f6cQV-00064h-Pp@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Cleanup covering infrastructure
- Explicitly forbids opclass, collation and indoptions (like DESC/ASC etc) for
including columns. Throw an error if user points that.
- Truncated storage arrays for such attributes to store only key atrributes,
added assertion checks.
- Do not check opfamily and collation for including columns in
CompareIndexInfo()
Discussion: https://www.postgresql.org/message-id/5ee72852-3c4e-ee35-e2ed-c1d053d45c08@sigaev.ru
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/c266ed31a8a3beed3533e6a78faeca78234cbd43
Modified Files
--------------
src/backend/catalog/index.c | 22 ++++++++++++++----
src/backend/commands/indexcmds.c | 44 +++++++++++++++++++++++++----------
src/backend/optimizer/path/indxpath.c | 40 +++++++++++++++++++++++--------
src/backend/optimizer/util/plancat.c | 4 ++--
src/backend/parser/parse_utilcmd.c | 3 ---
src/backend/utils/adt/ruleutils.c | 6 ++---
src/backend/utils/adt/selfuncs.c | 2 ++
src/backend/utils/cache/relcache.c | 8 +++----
8 files changed, 90 insertions(+), 39 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Teodor Sigaev | 2018-04-12 14:25:49 | pgsql: Fix interference between covering indexes and partitioned tables |
Previous Message | David Rowley | 2018-04-12 13:17:33 | Re: pgsql: Support partition pruning at execution time |