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

Title

Topic

Performance

Created

2017-07-20 22:42:11

Last modified

2017-11-30 03:02:37 (6 years, 9 months ago)

Latest email

2017-12-03 17:40:16 (6 years, 9 months 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

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