Reuse child_relids in try_partitionwise

Reuse child_relids in try_partitionwise_join

Title

Reuse child_relids in try_partitionwise_join

Topic

Performance

Created

2023-09-08 09:54:16

Last modified

2024-07-29 03:36:23 (1 month, 1 week ago)

Latest email

2024-07-29 03:44:16 (1 month, 1 week ago)

Status

2024-07: Committed

2024-03: Moved to next CF

2024-01: Moved to next CF

2023-11: Moved to next CF

Target version

Authors

Ashutosh Bapat (ashutoshbapat)

Reviewers

Richard Guo (richardguo)Become reviewer

Committer

Richard Guo (richardguo)

Links

Emails

Assert failure on bms_equal(child_joinrel->relids, child_joinrelids): First at 2023-07-21 10:02:10 by Richard Guo <guofenglinux at gmail.com>
Latest at 2024-07-29 03:44:16 by Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
Latest attachment (v1-0001-Reduce-memory-used-by-partitionwise-joins.patch) at 2024-07-26 09:44:33 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v1-0001-Reduce-memory-used-by-partitionwise-joins.patch) at 2024-07-26 09:44:33 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (0001-Avoid-repeated-computation-in-try_partition-20240724.patch) at 2024-07-24 07:30:23 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (child_bms_pwj_planning_time.ods) at 2024-06-10 07:08:54 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (setup.sql) at 2024-06-05 07:47:56 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0001-Reuse-child_relids-bitmapset-in-partitionwi-20240206.patch) at 2024-02-06 13:07:20 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-Reuse-child_relids-bitmapset-in-partitionwi-20231106.patch) at 2023-11-06 09:18:18 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-Reuse-child_relids-bitmapset-in-partitionwi-20231031.patch) at 2023-10-31 05:36:48 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Report-memory-used-for-planning-a-query-in--20230728.patch) at 2023-07-28 09:46:57 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-how-we-build-join-relids-for-child-join.patch) at 2023-07-21 10:02:10 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)

History

When	Who	What
2024-07-29 03:36:23	Richard Guo (richardguo)	Closed in commitfest 2024-07 with status: Committed
2024-07-29 03:36:23	Richard Guo (richardguo)	Changed committer to richardguo
2024-07-23 08:44:41	Richard Guo (richardguo)	Added richardguo as reviewer
2024-04-08 14:21:20	Andrey Borodin (x4m)	Closed in commitfest 2024-03 with status: Moved to next CF
2024-02-01 17:51:22	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-04 09:48:58	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-09-20 11:00:08	Ashutosh Bapat (ashutoshbapat)	Changed name to Reuse child_relids in try_partitionwise_join
2023-09-08 09:54:34	Ashutosh Bapat (ashutoshbapat)	Changed authors to Ashutosh Bapat (ashutoshbapat)
2023-09-08 09:54:16	Ashutosh Bapat (ashutoshbapat)	Attached mail thread CAMbWs49NCNbyubZWgci3o=_OTY=snCfAPtMnM-32f3mm-K-Ckw@mail.gmail.com
2023-09-08 09:54:16	Ashutosh Bapat (ashutoshbapat)	Created patch record