Postgres Pro
Downloads
Home   >   mailing lists

BUG #8274: Wildly insane boolean selectivity estimates - Mailing list pgsql-bugs

From andrew@tao11.riddles.org.uk
Subject BUG #8274: Wildly insane boolean selectivity estimates
Date
Msg-id E1Utfat-0001LU-N7@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8274: Wildly insane boolean selectivity estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled
Next
From: Fujii Masao
Date:
Subject: Re: BUG #8269: the recovery_target_inclusive is always considered as false