BUG #8274: Wildly insane boolean selectivity estimates

Поиск
Список
Период
Сортировка
От andrew@tao11.riddles.org.uk
Тема BUG #8274: Wildly insane boolean selectivity estimates
Дата
Msg-id E1Utfat-0001LU-N7@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #8274: Wildly insane boolean selectivity estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8274
Logged by:          Andrew Gierth
Email address:      andrew@tao11.riddles.org.uk
PostgreSQL version: 9.1.9
Operating system:   any
Description:

The guy on IRC who ran into this one was using 9.1.9, but it seems to still
exist in master.


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.


Suggested fix at:


https://gist.github.com/RhodiumToad/5901567

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: BUG #8269: the recovery_target_inclusive is always considered as false