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

Latest email

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

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