| From: | Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> |
|---|---|
| To: | Richard Guo <guofenglinux(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Memory consumed by child SpecialJoinInfo in partitionwise join planning |
| Date: | 2023-08-16 05:28:18 |
| Message-ID: | CAExHW5vpTpdaK0MATkLhx3_vAR2UZikeB5njzzx+WJrHKM1_sA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Aug 4, 2023 at 2:11 PM Ashutosh Bapat
<ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> wrote:
>
> Attached patchset fixing those.
> 0001 - patch to report planning memory, with to explain.out regression output fix. We may consider committing this as well.
> 0002 - with your comment addressed above.
0003 - Added this patch for handling SpecialJoinInfos for inner joins.
These SpecialJoinInfos are created on the fly for parent joins. They
can be created on the fly for child joins as well without requiring
any translations. Thus they do not require any new memory. This patch
is intended to be merged into 0002 finally.
Added to the upcoming commitfest https://commitfest.postgresql.org/44/4500/
--
Best Wishes,
Ashutosh Bapat
| Attachment | Content-Type | Size |
|---|---|---|
| 0003-Do-not-translate-dummy-SpecialJoinInfos-20230816.patch | text/x-patch | 7.9 KB |
| 0001-Report-memory-used-for-planning-a-query-in--20230816.patch | text/x-patch | 10.1 KB |
| 0002-Reduce-memory-used-by-child-SpecialJoinInfo-20230816.patch | text/x-patch | 6.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ajin Cherian | 2023-08-16 05:34:57 | Re: Synchronizing slots from primary to standby |
| Previous Message | Drouvot, Bertrand | 2023-08-16 05:04:53 | Re: WIP: new system catalog pg_wait_event |