Memory consumed by child SpecialJoinInfo in partitionwise join planning

Edit

ID 4500

Title Memory consumed by child SpecialJoinInfo in partitionwise join planning

Topic Performance

Created 2023-08-16 05:26:10

Last modified 2024-03-25 09:08:33 (7 months, 3 weeks ago)

Latest email 2024-03-25 10:56:34 (7 months, 3 weeks 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 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/4500
git checkout commitfest/cf/4500

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

Edit