Improve semijoin selectivity estimates by clamping them to not more than innerjoin equivalent

Edit
Title Improve semijoin selectivity estimates by clamping them to not more than innerjoin equivalent
Topic Bug Fixes
Created 2018-09-25 20:15:38
Last modified 2018-09-25 20:16:09 (3 weeks ago)
Latest email 2018-09-25 20:11:15 (3 weeks ago)
Status
2018-11: Needs review
Authors Tom Lane (tgl)
Reviewers Become reviewer
Committer
Links
Emails
BUG #15160: planner overestimates number of rows in join when there are more than 200 rows coming from CTE
First at 2018-04-17 09:40:50 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2018-09-25 20:11:15 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (clamp-semijoin-selectivity-1.patch) at 2018-09-25 20:11:15 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (clamp-semijoin-selectivity-1.patch) at 2018-09-25 20:11:15 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
History
When Who What
2018-09-25 20:16:09 Tom Lane (tgl) Changed authors to Tom Lane (tgl)
2018-09-25 20:16:09 Tom Lane (tgl) Changed topic to Bug Fixes
2018-09-25 20:15:38 Tom Lane (tgl) Attached mail thread 152395805004.19366.3107109716821067806@wrigleys.postgresql.org
2018-09-25 20:15:38 Tom Lane (tgl) Created patch record
Edit