Fix to not check included columns in ANALYZE on indexes

From: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Fix to not check included columns in ANALYZE on indexes
Date: 2018-06-28 11:53:07
Message-ID: 20180628205307.c720133a.nagata@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I found that both key columns and included columns are checked when analyze
is run on indexes. This is almost harmless because non-expression columns
are not processed. However, this check is obviously unnecessary and we
can fix this to not check included columns. If we decide to support expressions
in included columns in future, this must be fixed eventually.

Attached is a patch to fix this.

Regards,

--
Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>

Attachment Content-Type Size
analyze_only_index_key_attrs.patch text/x-diff 577 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Isaac Morland 2018-06-28 12:27:54 Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS
Previous Message Michael Paquier 2018-06-28 11:30:35 Re: partition tree inspection functions