pgsql: Cleanup covering infrastructure

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(-)

Browse pgsql-committers by date

  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