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

Edit
ID 1205
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 (7 years ago)
Latest email 2017-12-03 17:40:16 (7 years ago)
Status
2018-01: Committed
2017-11: Moved to next CF
2017-09: Moved to next CF
Target version
Authors Thomas Munro (macdice)
Reviewers Ashutosh Bapat (ashutoshbapat)Become reviewer
Committer Tom Lane (tgl)
Links CFbot results (CirrusCI) CFbot GitHub
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/1205
git checkout commitfest/cf/1205
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