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, 11 months ago)

Latest email

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

Status

2018-11: Committed

Target version

Authors

Tom Lane (tgl)

Reviewers

Melanie Plageman (melanieplageman)Become reviewer

Committer

Tom Lane (tgl)

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/1805
git checkout commitfest/cf/1805

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