Reducing memory consumed by RestrictInfo list translations in partitionwise join planning

Title

Topic

Performance

Created

2023-09-14 11:11:07

Last modified

2024-08-19 13:41:56 (3 weeks ago)

Latest email

2024-08-19 13:45:13 (3 weeks ago)

Status

2024-09: Needs review

2024-07: Moved to next CF

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

Become reviewer

Committer

Links

Emails

Reducing memory consumed by RestrictInfo list translations in partitionwise join planning: First at 2023-07-27 14:05:52 by Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
Latest at 2024-08-19 13:45:13 by Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
Latest attachment (0001-Avoid-translating-RestrictInfo-repeatedly-20240819.patch) at 2024-08-19 13:13:49 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
    Attachment (0001-Avoid-translating-RestrictInfo-repeatedly-20240819.patch) at 2024-08-19 13:13:49 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-Save-commuted-RestrictInfo-for-later-use-20240130.patch) at 2024-01-30 06:02:40 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-Free-intermediate-Relids-created-in-adjust_-20231031.patch) at 2023-10-31 05:17:44 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-Free-intermediate-Relids-created-in-adjust_-20230914.patch) at 2023-09-14 11:09:50 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0003-Construct-child-join-s-joininfo-and-restric-20230811.patch) at 2023-08-11 12:54:37 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Report-memory-used-for-planning-a-query-in--20230808.patch) at 2023-08-08 14:14:50 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (setup.sql) at 2023-07-27 14:05:52 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)

History

When	Who	What
2024-08-19 13:41:56	Ashutosh Bapat (ashutoshbapat)	New status: Needs review
2024-08-01 02:04:16	Corey Huinker (coreyh)	Closed in commitfest 2024-07 with status: Moved to next CF
2024-06-06 05:02:34	Ashutosh Bapat (ashutoshbapat)	New status: Waiting on Author
2024-04-08 14:56:02	Andrey Borodin (x4m)	Closed in commitfest 2024-03 with status: Moved to next CF
2024-02-01 17:51:34	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-04 09:49:13	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-09-20 11:00:44	Ashutosh Bapat (ashutoshbapat)	Changed authors to Ashutosh Bapat (ashutoshbapat)
2023-09-14 11:11:07	Ashutosh Bapat (ashutoshbapat)	Attached mail thread CAExHW5s=bCLMMq8n_bN6iU+Pjau0DS3z_6Dn6iLE69ESmsPMJQ@mail.gmail.com
2023-09-14 11:11:07	Ashutosh Bapat (ashutoshbapat)	Created patch record