Re: BUG #19040: Memory leak in hashed subplan node due to missing hashtempcxt reset

feichanghong <feichanghong@qq.com>

From: feichanghong <feichanghong@qq.com>

To: "李海洋(陌痕)" <mohen.lhy@alibaba-inc.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, ocean_li_996 <ocean_li_996@163.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>

Date: 2025-09-10T02:32:00Z

Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Eliminate duplicative hashtempcxt in nodeSubplan.c.
- bdc6cfcd12f5 19 (unreleased) landed
Fix memory leakage in nodeSubplan.c.
- e1da9c072106 16.11 landed
- bc865ff6d1f0 18.0 landed
- abdeacdb0920 19 (unreleased) landed
- 8b6c29afd125 13.23 landed
- 862980f924ff 17.7 landed
- 5eab9b0a473e 14.20 landed
- 5ac973892b09 15.15 landed
Do execGrouping.c via expression eval machinery, take two.
- bf6c614a2f2c 11.0 cited
Fix potential failure when hashing the output of a subplan that produces
- 133924e13e00 9.1.0 cited


> On Sep 10, 2025, at 09:55, 李海洋(陌痕) <mohen.lhy@alibaba-inc.com> wrote:
> 
> On 2025-09-09 22:24:22 Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
> > Digging in the archives, I found the discussion leading to 133924e1 at
> > https://www.postgresql.org/message-id/flat/i2jnbo%241lcj%241%40news.hub.org
> 
> 
> Having understood the background of this issue, and given that v04-0002 only applies to master, 
> v04-0002 LGTM, again.
> 
> Thanks for your analysis. 

Thanks for the analysis! v04-0002 looks fine to me — please just apply it on
HEAD.

Best Regards,
Fei Changhong