Reuse child_relids in try_partitionwise_join

Edit

ID 4553

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 (3 months, 3 weeks ago)

Latest email 2024-07-29 03:44:16 (3 months, 3 weeks 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 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/4553
git checkout commitfest/cf/4553

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

Edit