Horton

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

Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>

View thread View on postgr.es
From: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
To: Richard Guo <guofenglinux@gmail.com>
Cc: Amit Langote <amitlangote09@gmail.com>, Tender Wang <tndrwang@gmail.com>, pgsql-bugs@lists.postgresql.org, m_lingbin@126.com, Laurenz Albe <laurenz.albe@cybertec.at>
Date: 2025-02-19T04:59:03Z
Lists: pgsql-bugs 
On Wed, Feb 19, 2025 at 7:58 AM Richard Guo <guofenglinux@gmail.com> wrote:
>
> 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.


-- 
Best Wishes,
Ashutosh Bapat

Commits

  1. Fix freeing a child join's SpecialJoinInfo

  2. Reduce memory used by partitionwise joins