Convert NOT IN to anti-joins when possible

Edit
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 (4 years, 10 months ago)
Latest email 2019-11-28 02:30:21 (4 years, 10 months 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
Edit