Improve selectivity estimate for semi- and anti-join with <> quals

Edit
Title Improve selectivity estimate for semi- and anti-join with <> quals
Topic Performance
Created 2017-07-20 22:42:11
Last modified 2017-11-30 03:02:37 (1 year ago)
Latest email 2017-12-03 17:40:16 (1 year ago)
Status
2018-01: Committed
2017-11: Moved to next CF
2017-09: Moved to next CF
Authors Thomas Munro (macdice)
Reviewers Ashutosh Bapat (ashutoshbapat)Become reviewer
Committer Tom Lane (tgl)
Links
Emails
<> join selectivity estimate question
First at 2017-03-17 05:54:46 by Thomas Munro <thomas.munro at enterprisedb.com>
Latest at 2017-12-03 17:40:16 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (with-7ca25b7d.txt) at 2017-11-30 21:41:39 from Thomas Munro <thomas.munro at enterprisedb.com>
    Attachment (with-7ca25b7d.txt) at 2017-11-30 21:41:39 from Thomas Munro <thomas.munro at enterprisedb.com> (Patch: No)
    Attachment (neqjoinsel-fix-v4.patch) at 2017-09-06 11:14:15 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (neqjoinsel-fix-v3.patch) at 2017-07-20 22:40:43 from Thomas Munro <thomas.munro at enterprisedb.com> (Patch: Yes)
    Attachment (neqjoinsel-fix-v2.patch) at 2017-07-20 12:00:35 from Thomas Munro <thomas.munro at enterprisedb.com> (Patch: Yes)
    Attachment (neqjoinsel-fix-v1.patch) at 2017-07-20 05:34:51 from Thomas Munro <thomas.munro at enterprisedb.com> (Patch: Yes)
    Attachment (hacked_q21_4workers.txt) at 2017-03-17 22:49:13 from Thomas Munro <thomas.munro at enterprisedb.com> (Patch: No)
    Attachment (master_q21_3workers.txt) at 2017-03-17 05:54:46 from Thomas Munro <thomas.munro at enterprisedb.com> (Patch: No)
History
When Who What
2017-11-30 03:02:37 Tom Lane (tgl) Closed in commitfest 2018-01 with status: Committed
2017-11-30 02:06:06 Michael Paquier (michael-kun) Closed in commitfest 2017-11 with status: Moved to next CF
2017-11-30 02:00:19 Tom Lane (tgl) Added tgl as committer
2017-10-02 03:44:36 Thomas Munro (macdice) Closed in commitfest 2017-09 with status: Moved to next CF
2017-08-16 15:04:29 Ashutosh Bapat (ashutoshbapat) Added ashutoshbapat as reviewer
2017-07-20 22:42:23 Thomas Munro (macdice) Changed authors to Thomas Munro (macdice)
2017-07-20 22:42:11 Thomas Munro (macdice) Attached mail thread CAEepm=270ze2hVxWkJw-5eKzc3AB4C9KpH3L2kih75R5pdSogg@mail.gmail.com
2017-07-20 22:42:11 Thomas Munro (macdice) Created patch record
Edit