Re: Large join runs out of memory in 8.1

Joe Sunday <sunday@csh.rit.edu> writes:
> On Tue, Mar 14, 2006 at 11:29:57PM -0500, Tom Lane wrote:
>> What I'd try is first letting the problem case run for a bit, then
>> stopping it with gdb and dumping out a few Kb of the frontmost memory
>> block in the ExecutorState context.  Sometimes, looking at the data

> Can you point me a little more in that direction? I can't figure out how
> to get a handle to that context.

Well, it's nearly hopeless with a non-debug build, which is what you
seem to have there :-(.  With debug symbols, printing the parameter
passed to AllocSetAlloc is easy enough.

            regards, tom lane