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 (2 weeks, 5 days ago)

Latest email 2024-11-25 05:50:05 (3 weeks, 5 days 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