Reducing memory consumed by RestrictInfo list translations in partitionwise join planning

Edit
ID 4564
Title Reducing memory consumed by RestrictInfo list translations in partitionwise join planning
Topic Performance
Created 2023-09-14 11:11:07
Last modified 2024-12-01 19:11:12 (1 day, 21 hours ago)
Latest email 2024-11-25 05:50:05 (1 week, 1 day ago)
Status
2025-01: Needs review
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 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/4564
git checkout commitfest/cf/4564
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-11-25 05:50:05 by Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
Latest 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>
    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
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