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

Edit
ID 1805
Title Improve semijoin selectivity estimates by clamping them to not more than innerjoin equivalent
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Bug Fixes
Tags
Created 2018-09-25 20:15:38
Last modified 2018-11-23 17:49:09 (6 years ago)
Latest email 2018-11-23 17:17:34 (6 years ago)
Status
2018-11 (2018-11-01 – 2018-11-30): Committed
Target version
Authors Tom Lane (tgl)
Reviewers Melanie Plageman (melanieplageman)Become reviewer
Committer Tom Lane (tgl)
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-11-23 17:17:34 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (suggested_semijoin_selec_refactor.patch) at 2018-11-16 18:31:47 from Melanie Plageman <melanieplageman at gmail.com>
    Attachment (suggested_semijoin_selec_refactor.patch) at 2018-11-16 18:31:47 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    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-11-23 17:49:09 Tom Lane (tgl) Closed in commitfest 2018-11 with status: Committed
2018-11-23 17:49:09 Tom Lane (tgl) Changed committer to tgl
2018-11-20 20:25:31 Melanie Plageman (melanieplageman) New status: Ready for Committer
2018-11-16 00:51:45 Melanie Plageman (melanieplageman) Posted review with messageid <154232950503.1400.7562962199586713542.pgcf@coridan.postgresql.org>
2018-11-16 00:51:45 Melanie Plageman (melanieplageman) New status: Waiting on Author
2018-11-06 02:18:21 Melanie Plageman (melanieplageman) Added melanieplageman as reviewer
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