Memory consumed by child SpecialJoinInfo in partitionwise join planning

Title

Topic

Performance

Created

2023-08-16 05:26:10

Last modified

2024-03-25 09:08:33 (1 month ago)

Latest email

2024-03-25 10:56:34 (1 month ago)

Status

2024-03: Committed

2024-01: Moved to next CF

2023-11: Moved to next CF

2023-09: Moved to next CF

Target version

Authors

Ashutosh Bapat (ashutoshbapat)

Reviewers

Amit Langote (amitlan)Become reviewer

Committer

Amit Langote (amitlan)

Links

Emails

Memory consumed by child SpecialJoinInfo in partitionwise join planning: First at 2023-07-27 14:09:45 by Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
Latest at 2024-03-25 10:56:34 by Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
Latest attachment (v1-0001-Fix-the-comment-of-init_dummy_sjinfo.patch) at 2024-03-25 10:25:19 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v1-0001-Fix-the-comment-of-init_dummy_sjinfo.patch) at 2024-03-25 10:25:19 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (0002-Minor-edits-20240322.patch) at 2024-03-22 10:48:38 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v1-0002-Some-fixes.patch) at 2024-03-22 09:23:42 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0002-Address-Amit-s-comments-20240318.patch) at 2024-03-18 11:11:27 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-Address-Amit-s-comments-20240130.patch) at 2024-01-30 05:44:44 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Report-memory-used-for-planning-a-query-in--20231003.patch) at 2023-10-03 13:12:28 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0003-Address-Amit-s-comments-20230927.patch) at 2023-09-27 11:07:38 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0003-Do-not-translate-dummy-SpecialJoinInfos-20230816.patch) at 2023-08-16 05:28:18 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-Reduce-memory-used-by-child-SpecialJoinInfo-20230804.patch) at 2023-08-04 08:41:56 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (queries.sql) at 2023-07-27 14:09:45 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)

History

When	Who	What
2024-03-25 09:08:33	Amit Langote (amitlan)	Closed in commitfest 2024-03 with status: Committed
2024-03-22 05:09:01	Amit Langote (amitlan)	Added amitlan as committer
2024-03-18 12:04:18	Amit Langote (amitlan)	Added amitlan as reviewer
2024-02-01 17:46:38	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-04 09:54:03	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 09:47:27	Peter Eisentraut (petere)	Closed in commitfest 2023-09 with status: Moved to next CF
2023-09-12 06:38:38	Peter Eisentraut (petere)	Changed reviewers to
2023-08-16 05:26:44	Ashutosh Bapat (ashutoshbapat)	Changed reviewers to Richard Guo (richardguo)
2023-08-16 05:26:44	Ashutosh Bapat (ashutoshbapat)	Changed authors to Ashutosh Bapat (ashutoshbapat)
2023-08-16 05:26:10	Ashutosh Bapat (ashutoshbapat)	Attached mail thread CAExHW5tHqEf3ASVqvFFcghYGPfpy7o3xnvhHwBGbJFMRH8KjNw@mail.gmail.com
2023-08-16 05:26:10	Ashutosh Bapat (ashutoshbapat)	Created patch record