Re: BUG #8274: Wildly insane boolean selectivity estimates

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #8274: Wildly insane boolean selectivity estimates
Дата
Msg-id 4165.1374639748@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #8274: Wildly insane boolean selectivity estimates  (andrew@tao11.riddles.org.uk)
Список pgsql-bugs
andrew@tao11.riddles.org.uk writes:
> The handling of freq_null for estimating IS NOT TRUE/FALSE for boolean
> columns which are all null or almost all null (enough that analyze doesn't
> find any non-null values to put in MCV) is completely off in the weeds.

Doh, definitely a bit of brain fade there :-(

> Suggested fix at:
> https://gist.github.com/RhodiumToad/5901567

Seems reasonable, will fix.

            regards, tom lane

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