Fix to not check included columns in ANALYZE on indexes

Поиск
Список
Период
Сортировка
От Yugo Nagata
Тема Fix to not check included columns in ANALYZE on indexes
Дата
Msg-id 20180628205307.c720133a.nagata@sraoss.co.jp
обсуждение исходный текст
Ответы Re: Fix to not check included columns in ANALYZE on indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@sraoss.co.jp>

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: partition tree inspection functions
Следующее
От: Isaac Morland
Дата:
Сообщение: Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS