Re: Are statistics gathered on function indexes?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Are statistics gathered on function indexes?
Дата
Msg-id 15121.1034997200@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Are statistics gathered on function indexes?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Awhile back I said:
> Oh, I see it: range selectivity double-excludes NULLs.  See the comment
> for clauselist_selectivity in src/backend/optimizer/path/clausesel.c.
> The individual estimates for the two component comparison operators
> each exclude nulls, and when we merge them together we get the wrong
> answer.

Just FYI, I have fixed this for 7.3.

            regards, tom lane

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