NOT IN to ANTI JOIN transformation

Edit
Title NOT IN to ANTI JOIN transformation
Topic Performance
Created 2019-02-25 18:06:49
Last modified 2020-04-08 13:32:16 (3 years, 11 months ago)
Latest email 2020-04-08 13:32:09 (3 years, 11 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
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