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

From Tom Lane
Subject Re: Large join runs out of memory in 8.1
Date
Msg-id 16478.1142396997@sss.pgh.pa.us
Whole thread Raw
In response to Re: Large join runs out of memory in 8.1  (Joe Sunday <sunday@csh.rit.edu>)
Responses Re: Large join runs out of memory in 8.1
List pgsql-bugs
Joe Sunday <sunday@csh.rit.edu> writes:
> It'll take me a while to come up with a dataset I can distribute that
> causes it. My first pass at fake random data didn't seem to trigger it,
> and I can't divulge the real data.

> I can poke with gdb, is there a guide for what to look for somewhere?

It's not the easiest sort of problem to debug :-( ...

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
that's being leaked is enough to give you a clue.  If not, try setting a
breakpoint at AllocSetAlloc and trying to see where the majority of
calls are coming from.  It'll be tedious ...

If you get bored, I'm willing to sign an NDA covering the data involved.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Joe Sunday
Date:
Subject: Re: Large join runs out of memory in 8.1
Next
From: "Lin, B (Bill)"
Date:
Subject: Re: Random hang during commit