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-19T02:28:42Z
Lists: pgsql-bugs 
On Tue, Feb 18, 2025 at 3:52 PM Richard Guo <guofenglinux@gmail.com> wrote:
> 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.

Pushed and back-patched to v17.  The fix will be included in the next
minor release (17.5).

Thanks
Richard

Commits

  1. Fix freeing a child join's SpecialJoinInfo

  2. Reduce memory used by partitionwise joins