Reducing memory consumed by RestrictInfo list translations in partitionwise join planning

Edit

4564

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v9, Patch count: 2, First patch: +3−0, All patches: +389−77

Topic

Performance

Created

2023-09-14 11:11:07

Last modified

2025-04-04 07:36:19 (1 week ago)

Latest email

2025-04-04 08:52:08 (1 week ago)

Status

2025-03: Committed

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

Amit Langote (amitlan)

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-04-04 08:52:08 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (v9-0002-Make-derived-clause-lookup-in-EquivalenceClass-mo.patch) at 2025-04-03 03:28:09 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v9-0002-Make-derived-clause-lookup-in-EquivalenceClass-mo.patch) at 2025-04-03 03:28:09 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-Add-assertion-to-verify-derived-clause-has--20250402.patch) at 2025-04-02 12:51:59 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Add-assertion-to-verify-derived-clause-has-consta.patch) at 2025-04-02 07:30:20 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-Add-assertion-to-verify-derived-clause-has--20250401.patch) at 2025-04-01 16:58:25 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v6-0003-Canonicalize-keys-for-derived-clause-hash-table.patch) at 2025-04-01 08:01:54 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-Add-assertion-to-verify-derived-clause-has--20250331.patch) at 2025-03-31 10:00:40 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Add-assertion-to-verify-derived-clause-has--20250328.patch) at 2025-03-28 16:46:15 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (partbench.sh.txt) at 2025-03-28 03:02:10 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (EffectOfHashTablePlannerMemoryPWJON27Mar2025.png) at 2025-03-27 10:27:35 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v4-0002-Make-derived-clause-lookup-in-EquivalenceClass-mo.patch) at 2025-03-25 11:50:38 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0002-Make-derived-clause-lookup-in-EquivalenceCl-20250325.patch) at 2025-03-25 09:35:55 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Add-assertion-to-verify-derived-clause-has-consta.patch) at 2025-03-25 07:28:15 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (amit-delta-suggestions.diff.txt) at 2025-03-25 06:16:53 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v2-0003-amit-delta.patch) at 2025-03-24 13:52:58 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    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-04-04 07:36:19	Amit Langote (amitlan)	Closed in commitfest 2025-03 with status: Committed
2025-04-04 07:36:19	Amit Langote (amitlan)	Changed committer to amitlan
2025-04-03 01:20:42	Ashutosh Bapat (ashutoshbapat)	New status: Needs review
2025-04-02 08:16:47	Ashutosh Bapat (ashutoshbapat)	Closed in commitfest 2025-03 with status: Committed
2025-04-02 08:16:47	Ashutosh Bapat (ashutoshbapat)	Changed committer to alvherre
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