Convert NOT IN to anti-joins when possible

ID 2020

Title Convert NOT IN to anti-joins when possible

Topic Performance

Created 2019-02-25 12:33:25

Last modified 2019-11-28 02:30:33 (5 years ago)

Latest email 2019-11-28 02:30:21 (5 years ago)

Status

2019-11: Returned with feedback

2019-09: Moved to next CF

2019-07: Moved to next CF

2019-03: Moved to next CF

Target version 13

Authors David Rowley (davidrowley)

Reviewers Antonin Houska (a.houska)Become reviewer

Committer

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/2020
git checkout commitfest/cf/2020

Emails

Converting NOT IN to anti-joins during planning: First at 2019-03-05 23:54:49 by David Rowley <david.rowley at 2ndquadrant.com>
Latest at 2019-11-28 02:30:21 by Michael Paquier <michael at paquier.xyz>
Latest attachment (not_in_anti_join_v2.patch) at 2019-07-01 11:23:34 from David Rowley <david.rowley at 2ndquadrant.com>
    Attachment (not_in_anti_join_v2.patch) at 2019-07-01 11:23:34 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (not_in_anti_join_v1.4.patch) at 2019-05-24 11:46:20 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (not_in_anti_join_v1.3.patch) at 2019-03-05 23:54:49 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)

History

When	Who	What
2019-11-28 02:30:33	Michael Paquier (michael-kun)	Closed in commitfest 2019-11 with status: Returned with feedback
2019-09-03 01:15:38	David Rowley (davidrowley)	New status: Waiting on Author
2019-09-03 01:15:18	David Rowley (davidrowley)	Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-03 01:15:09	David Rowley (davidrowley)	New status: Needs review
2019-08-13 09:54:45	Antonin Houska (a.houska)	New status: Waiting on Author
2019-08-01 22:32:44	Thomas Munro (macdice)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-07-01 12:01:11	David Rowley (davidrowley)	New status: Needs review
2019-05-27 08:50:43	Antonin Houska (a.houska)	New status: Waiting on Author
2019-05-27 08:50:36	Antonin Houska (a.houska)	Added a.houska as reviewer
2019-04-06 03:08:28	David Rowley (davidrowley)	Closed in commitfest 2019-03 with status: Moved to next CF
2019-03-05 23:55:45	David Rowley (davidrowley)	Attached mail thread CAKJS1f82pqjqe3WT9_xREmXyG20aOkHc-XqkKZG_yMA7JVJ3Tw@mail.gmail.com
2019-03-05 23:55:38	David Rowley (davidrowley)	Detached mail thread 1550706289606-0.post@n3.nabble.com
2019-02-28 11:12:29	David Rowley (davidrowley)	Changed targetversion to 13
2019-02-25 12:33:37	David Rowley (davidrowley)	Changed authors to David Rowley (davidrowley)
2019-02-25 12:33:25	David Rowley (davidrowley)	Attached mail thread 1550706289606-0.post@n3.nabble.com
2019-02-25 12:33:25	David Rowley (davidrowley)	Created patch record