Re: pgsql: Support index INCLUDE in the AM properties interface.

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Andrew Gierth <rhodiumtoad(at)postgresql(dot)org>, pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Support index INCLUDE in the AM properties interface.
Date: 2018-04-08 07:55:30
Message-ID: 5968c973-98fb-16bb-efa6-b6cb518fc36a@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Thank you!

Andrew Gierth wrote:
> Support index INCLUDE in the AM properties interface.
>
> This rectifies an oversight in commit 8224de4f4, by adding a new
> property 'can_include' for pg_indexam_has_property, and adjusting the
> results of pg_index_column_has_property to give more appropriate
> results for INCLUDEd columns.
>
> Branch
> ------
> master
>
> Details
> -------
> https://git.postgresql.org/pg/commitdiff/49b0e300f7dd56b092c0046ee29dc2b15beea9a8
>
> Modified Files
> --------------
> doc/src/sgml/func.sgml | 6 ++
> src/backend/utils/adt/amutils.c | 158 +++++++++++++++++++++++-----------
> src/include/access/amapi.h | 9 +-
> src/test/regress/expected/amutils.out | 57 ++++++++++--
> src/test/regress/sql/amutils.sql | 17 +++-
> 5 files changed, 185 insertions(+), 62 deletions(-)
>

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2018-04-08 14:41:34 Re: pgsql: Indexes with INCLUDE columns and their support in B-tree
Previous Message Andrew Gierth 2018-04-08 07:31:48 Re: pgsql: Support partition pruning at execution time