NOT IN to ANTI JOIN transformation

Edit

2023

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Performance

Created

2019-02-25 18:06:49

Last modified

2020-04-08 13:32:16 (5 years ago)

Latest email

2020-04-08 13:32:09 (5 years 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

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