Horton

Re: BUG #18806: When enable_rartitionwise_join is set to ON, the database shuts down abnormally

Richard Guo <guofenglinux@gmail.com>

View thread View on postgr.es
From: Richard Guo <guofenglinux@gmail.com>
To: Amit Langote <amitlangote09@gmail.com>
Cc: Tender Wang <tndrwang@gmail.com>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, pgsql-bugs@lists.postgresql.org, m_lingbin@126.com, Laurenz Albe <laurenz.albe@cybertec.at>
Date: 2025-02-18T06:52:01Z
Lists: pgsql-bugs 
On Tue, Feb 18, 2025 at 2:03 PM Amit Langote <amitlangote09@gmail.com> wrote:
> I'm inclined to go with Richard's proposal, mainly to avoid the
> overhead of copying in a bug fix just to isolate child sjinfo from
> parent_sjinfo.
>
> Richard, would you like to commit the patch you proposed (adding
> parent_sjinfo as a parameter to free_child_join_sjinfo()), or would
> you prefer that I do it?

Thank you Amit for reviewing.  I'll commit it and will do so shortly.

Thanks
Richard

Commits

  1. Fix freeing a child join's SpecialJoinInfo

  2. Reduce memory used by partitionwise joins