Re: Fix to not check included columns in ANALYZE on indexes
От | Tom Lane |
---|---|
Тема | Re: Fix to not check included columns in ANALYZE on indexes |
Дата | |
Msg-id | 25504.1530227916@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Fix to not check included columns in ANALYZE on indexes (Yugo Nagata <nagata@sraoss.co.jp>) |
Ответы |
Re: Fix to not check included columns in ANALYZE on indexes
Re: Fix to not check included columns in ANALYZE on indexes Re: Fix to not check included columns in ANALYZE on indexes |
Список | pgsql-hackers |
Yugo Nagata <nagata@sraoss.co.jp> writes: > 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. AFAICS, we'd just have to revert this patch later, so I don't see much value in it. Also, is it really true that we don't support included expression columns now? In what way would that not be a bug? regards, tom lane
В списке pgsql-hackers по дате отправления: