Re: Large join runs out of memory in 8.1 - Mailing list pgsql-bugs

Joe Sunday <sunday@csh.rit.edu> writes:
> On Tue, Mar 14, 2006 at 03:56:51PM -0500, Tom Lane wrote:
>> This error should result in dumping a list of per-context memory usage
>> into the postmaster log ... could we have a look at that?

> Here you go:
> ...
> ExecutorState: -346079744 total in 476747 blocks; 1498632 free (15 chunks); -347578376 used

Ick, definitely something leaking in the ExecutorState context.  I can't
guess what though.  Do you want to put together a self-contained test
case for us to look at, or dig into it with gdb yourself?

            regards, tom lane