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

Title

Topic

Bug Fixes

Created

2018-09-25 20:15:38

Last modified

2018-11-23 17:49:09 (5 years, 4 months ago)

Latest email

2018-11-23 17:17:34 (5 years, 4 months ago)

Status

2018-11: 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