Horton

Re: BUG #17844: Memory consumption for memoize node

David Rowley <dgrowleyml@gmail.com>

View thread View on postgr.es
From: David Rowley <dgrowleyml@gmail.com>
To: Alexey Ermakov <alexey.ermakov@dataegret.com>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2023-03-20T20:36:26Z
Lists: pgsql-bugs 
On Mon, 20 Mar 2023 at 19:23, Alexey Ermakov
<alexey.ermakov@dataegret.com> wrote:
> Thanks a lot! Could you please point me in the direction how to get such
> memory stats ? I might know another memory leak I'd like to check but
> sadly I don't know right tools to measure memory usage.

I attached to the backend with a debugger and set a breakpoint in
ExecEndMemoize. When the breakpoint was hit, using the debugger, I
executed MemoryContextStatsDetail(TopMemoryContext, 100, 1) and
grabbed the memory statistics output from the log.

David

Commits

  1. Have the planner account for the Memoize cache key memory

  2. Fix memory leak in Memoize cache key evaluation