Fix handling of full outer joins by partitionwise join

Title

Topic

Performance

Created

2019-09-04 01:50:41

Last modified

2020-04-08 02:12:50 (4 years ago)

Latest email

2020-04-08 02:53:44 (4 years ago)

Status

2020-03: Committed

2020-01: Moved to next CF

2019-11: Moved to next CF

Target version

Authors

Amit Langote (amitlan)

Reviewers

Tom Lane (tgl), Justin Pryzby (justinpryzby), Richard Guo (richardguo)Become reviewer

Committer

Tom Lane (tgl)

Links

Emails

d25ea01275 and partitionwise join: First at 2019-07-02 09:28:58 by Amit Langote <amitlangote09 at gmail.com>
Latest at 2020-04-08 02:53:44 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (v8-0001-Fix-partitionwise-join-to-handle-FULL-JOINs-corre.patch) at 2020-04-06 17:41:06 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v8-0001-Fix-partitionwise-join-to-handle-FULL-JOINs-corre.patch) at 2020-04-06 17:41:06 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v7-test-delta.patch) at 2020-04-06 15:19:21 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Fix-partitionwise-join-to-handle-FULL-JOINs-corre.patch) at 2020-04-05 22:29:04 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v6-0001-Fix-partitionwise-join-to-handle-FULL-JOINs-corre.patch) at 2020-04-04 09:31:37 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v5-0002-Move-some-code-from-joinrel.c-to-relnode.c.patch) at 2020-03-01 14:21:29 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-Some-cosmetic-improvements-to-partitionwise-join-cod.patch) at 2019-11-06 09:40:09 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v3-0003-Add-multi-relation-EC-child-members-in-a-separate.patch) at 2019-09-19 08:15:37 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Some-cosmetic-improvements-to-partitionwise-join-.patch) at 2019-07-18 02:18:11 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-partitionwise-join-code-to-handle-FULL-OUTER-JOI.patch) at 2019-07-02 09:28:58 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)

History

When	Who	What
2020-04-08 02:12:50	Tom Lane (tgl)	Closed in commitfest 2020-03 with status: Committed
2020-04-08 02:12:50	Tom Lane (tgl)	Changed committer to tgl
2020-04-04 16:12:43	Tom Lane (tgl)	New status: Needs review
2020-04-03 21:13:55	Tom Lane (tgl)	Added tgl as reviewer
2020-04-03 21:03:23	Tom Lane (tgl)	New status: Waiting on Author
2020-02-01 12:51:28	Tomas Vondra (fuzzycz)	Closed in commitfest 2020-01 with status: Moved to next CF
2019-11-29 06:34:15	Michael Paquier (michael-kun)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-11-06 18:39:18	Tom Lane (tgl)	New status: Needs review
2019-11-05 16:49:06	Tom Lane (tgl)	New status: Waiting on Author
2019-10-15 01:38:20	Justin Pryzby (justinpryzby)	Added justinpryzby as reviewer
2019-09-04 08:46:05	Richard Guo (richardguo)	Added richardguo as reviewer
2019-09-04 01:50:52	Amit Langote (amitlan)	Changed authors to Amit Langote (amitlan)
2019-09-04 01:50:41	Amit Langote (amitlan)	Attached mail thread CA+HiwqG2WVUGmLJqtR0tPFhniO=H=9qQ+Z3L_ZC+Y3-EVQHFGg@mail.gmail.com
2019-09-04 01:50:41	Amit Langote (amitlan)	Created patch record