pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: feichanghong <feichanghong@qq.com>
Cc: "李海洋(陌痕)" <mohen.lhy@alibaba-inc.com>
Cc: ocean_li_996 <ocean_li_996@163.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #19040: Memory leak in hashed subplan node due to missing hashtempcxt reset
Date: Mon, 08 Sep 2025 23:05:09 -0400
Message-ID: <1073615.1757387109@sss.pgh.pa.us> (raw)
In-Reply-To: <tencent_8ED17B52864FA7C5479B890C071A8281D206@qq.com>
References: <19040-c9b6073ef814f48c@postgresql.org>
	<58062871.112.1990d3e06ea.Coremail.ocean_li_996@163.com>
	<tencent_8E54DE49323C3A293EE44DFE385011189509@qq.com>
	<808767.1756913726@sss.pgh.pa.us>
	<c765ad39-39eb-4a39-8e67-91bcb9ee65e0.mohen.lhy@alibaba-inc.com>
	<160523.1757190713@sss.pgh.pa.us>
	<bfb8be51-18e5-4839-a555-5c3d0ccd32d0.mohen.lhy@alibaba-inc.com>
	<tencent_0C8392F1FB41065427D6C7AC8919073F8206@qq.com>
	<507583.1757352192@sss.pgh.pa.us>
	<721997.1757364370@sss.pgh.pa.us>
	<tencent_8ED17B52864FA7C5479B890C071A8281D206@qq.com>

feichanghong <feichanghong@qq.com> writes:
> For v04-0002, I checked the commit history, and before commit 133924e1,
> buildSubPlanHash was using ecxt_per_tuple_memory. It seems that the
> "Subplan HashTable Temp Context" was introduced in order to fix a certain bug.

It was a different ExprContext's ecxt_per_tuple_memory, though.
This one is owned locally by the TupleHashTable.

			regards, tom lane





view thread (19+ messages)  latest in thread

Message-ID: <1073615.1757387109@sss.pgh.pa.us>
Permalink:  ../1073615.1757387109@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1073615.1757387109@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, feichanghong@qq.com, mohen.lhy@alibaba-inc.com, ocean_li_996@163.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #19040: Memory leak in hashed subplan node due to missing hashtempcxt reset
  In-Reply-To: <1073615.1757387109@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox