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
CI (CFBot) Summary
Stats (from CFBot) Patch version: v9, Patch count: 2, First patch: +3−0, All patches: +389−77
Topic Performance
Tags
Created 2023-09-14 11:11:07
Last modified 2025-04-04 07:36:19 (6 months ago)
Latest email 2025-04-04 08:52:08 (6 months ago)
Status
2025-03 (2025-03-01 – 2025-04-08): Committed
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
2024-03 (2024-03-01 – 2024-04-08): Moved to different CF
2024-01 (2024-01-01 – 2024-01-31): Moved to different CF
2023-11 (2023-11-01 – 2023-12-04): Moved to different 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