Reducing memory consumed by RestrictInfo list translations in partitionwise join planning

Edit

4564

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch count: 2, First patch: +3−0, All patches: +312−76

Topic

Performance

Created

2023-09-14 11:11:07

Last modified

2025-02-04 07:52:34 (1 month, 1 week ago)

Latest email

2025-02-25 11:04:28 (2 weeks ago)

Status

2025-03: Needs review

2025-01: Moved to next CF

2024-11: Moved to next CF

2024-09: Moved to next CF

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 2025-02-25 11:04:28 by Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
Latest attachment (0001-Add-Assert-in-find_derived_clause_for_ec_me-20250225.patch) at 2025-02-25 11:04:28 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
    Attachment (0001-Add-Assert-in-find_derived_clause_for_ec_me-20250225.patch) at 2025-02-25 11:04:28 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-RestrictInfo-hash-table-interface-20250220.patch) at 2025-02-20 11:58:48 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (PWJ memory consumption with RestrictInfo fixes - 8 Oct 2024.xlsx) at 2024-11-25 05:50:05 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0004-Avoid-translating-RestrictInfo-repeatedly-20241010.patch) at 2024-10-10 12:06:10 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    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
2025-02-20 12:01:39	CFbot	Patch does not need rebase anymore
2025-02-18 11:54:14	CFbot	Patch needs rebase
2025-02-04 07:52:34	Ashutosh Bapat (ashutoshbapat)	Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-01 19:11:12	Dmitry Dolgov (erthalion)	Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-08 01:57:07	Michael Paquier (michael-kun)	Closed in commitfest 2024-09 with status: Moved to next CF
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

Edit