NOT IN to ANTI JOIN transformation

Edit
Comment/Review
Change Status
ID 2023
Title NOT IN to ANTI JOIN transformation
Topic Performance
Created 2019-02-25 18:06:49
Last modified 2020-04-08 13:32:16 (4 years, 7 months ago)
Latest email 2020-04-08 13:32:09 (4 years, 7 months ago)
Status
2020-03: Returned with feedback
2020-01: Moved to next CF
2019-11: Moved to next CF
2019-09: Moved to next CF
2019-07: Moved to next CF
2019-03: Moved to next CF
Target version 13
Authors James Finnerty (jimfinnerty), Zheng Li (zhengli)
Reviewers 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/2023
git checkout commitfest/cf/2023
Emails
NOT IN subquery optimization
First at 2019-02-20 23:44:49 by Jim Finnerty <jfinnert at amazon.com>
Latest at 2019-06-14 21:41:06 by "Li, Zheng" <zhelli at amazon.com>
Latest attachment (not_in_to_anti_join_transformation_v2.patch) at 2019-06-14 21:41:06 from "Li, Zheng" <zhelli at amazon.com>
    Attachment (not_in_to_anti_join_transformation_v2.patch) at 2019-06-14 21:41:06 from "Li, Zheng" <zhelli at amazon.com> (Patch: Yes)
    Attachment (not_in_to_anti_join_transformation_v2.patch) at 2019-03-16 21:07:04 from "Li, Zheng" <zhelli at amazon.com> (Patch: Yes)
    Attachment (not_in_anti_join_v1.3.patch) at 2019-03-03 13:34:42 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (not_in_anti_join_v1.2.patch) at 2019-03-03 03:53:31 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (not_in_empty_subquery_test.sql) at 2019-03-01 22:28:00 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (not_in_anti_join_transformation_v1.patch) at 2019-02-25 22:51:30 from "Li, Zheng" <zhelli at amazon.com> (Patch: Yes)
    Attachment (not_in_anti_join_transformation.patch) at 2019-02-25 17:38:22 from "Li, Zheng" <zhelli at amazon.com> (Patch: Yes)
    Attachment (not_in_anti_join_v1.1.patch) at 2019-02-25 12:31:53 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (not_in_anti_join_v1.0.patch) at 2019-02-21 20:44:14 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
Re: NOT IN subquery optimization
First at 2019-06-18 20:22:30 by "Li, Zheng" <zhelli at amazon.com>
Latest at 2020-04-08 13:32:09 by David Steele <david at pgmasters.net>
Latest attachment (not_in_to_anti_join_transformation_v2_4.patch) at 2020-03-24 20:29:11 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (not_in_to_anti_join_transformation_v2_4.patch) at 2020-03-24 20:29:11 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (not_in_to_anti_join_transformation_v2_3.patch) at 2019-12-02 16:25:20 from "Li, Zheng" <zhelli at amazon.com> (Patch: Yes)
    Attachment (not_in_to_anti_join_transformation_v2_2.patch) at 2019-06-26 21:26:16 from "Li, Zheng" <zhelli at amazon.com> (Patch: Yes)
    Attachment (not_in_to_anti_join_transformation_v2_1.patch) at 2019-06-18 20:22:30 from "Li, Zheng" <zhelli at amazon.com> (Patch: Yes)
History
When Who What
2020-04-08 13:32:16 David Steele (dsteele) Closed in commitfest 2020-03 with status: Returned with feedback
2020-03-24 20:46:25 Tom Lane (tgl) New status: Waiting on Author
2020-02-01 12:50:11 Tomas Vondra (fuzzycz) Closed in commitfest 2020-01 with status: Moved to next CF
2020-01-13 02:54:46 Weinan Wang (wewang) Detached mail thread 871rsa13ae.fsf@wibble.ilmari.org
2020-01-13 02:53:09 Weinan Wang (wewang) Attached mail thread 871rsa13ae.fsf@wibble.ilmari.org
2019-12-02 16:26:27 Zheng Li (zhengli) New status: Needs review
2019-12-01 03:43:23 Michael Paquier (michael-kun) New status: Waiting on Author
2019-12-01 03:43:19 Michael Paquier (michael-kun) Closed in commitfest 2019-11 with status: Moved to next CF
2019-09-30 18:56:46 Álvaro Herrera (alvherre) Closed in commitfest 2019-09 with status: Moved to next CF
2019-08-01 22:46:56 Thomas Munro (macdice) Closed in commitfest 2019-07 with status: Moved to next CF
2019-06-28 16:06:09 Zheng Li (zhengli) Attached mail thread 61BFFE8C-F884-4936-BB28-0098283F4719@amazon.com
2019-04-06 20:39:04 David Steele (dsteele) Closed in commitfest 2019-03 with status: Moved to next CF
2019-03-18 15:18:02 Zheng Li (zhengli) New status: Needs review
2019-03-05 08:20:33 David Steele (dsteele) Changed targetversion to 13
2019-03-01 12:53:20 David Rowley (davidrowley) New status: Waiting on Author
2019-02-27 17:35:42 Zheng Li (zhengli) Changed targetversion to None
2019-02-27 17:35:17 Zheng Li (zhengli) Changed targetversion to 13
2019-02-25 18:09:36 Zheng Li (zhengli) Changed authors to James Finnerty (jimfinnerty), Zheng Li (zhengli)
2019-02-25 18:07:29 Zheng Li (zhengli) Changed targetversion to 12
2019-02-25 18:06:49 Zheng Li (zhengli) Attached mail thread 1550706289606-0.post@n3.nabble.com
2019-02-25 18:06:49 Zheng Li (zhengli) Created patch record
Edit
Comment/Review
Change Status