Re: [BUGS] Large join runs out of memory in 8.1

2006-03-15 Thread Joe Sunday
On Wed, Mar 15, 2006 at 01:10:41PM -0500, Tom Lane wrote: > Joe Sunday <[EMAIL PROTECTED]> 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 frontmo

Re: [BUGS] Large join runs out of memory in 8.1

2006-03-15 Thread Tom Lane
Joe Sunday <[EMAIL PROTECTED]> 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, lookin

Re: [BUGS] Large join runs out of memory in 8.1

2006-03-15 Thread Joe Sunday
On Tue, Mar 14, 2006 at 11:29:57PM -0500, Tom Lane wrote: > 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. S

Re: [BUGS] Large join runs out of memory in 8.1

2006-03-14 Thread Tom Lane
Joe Sunday <[EMAIL PROTECTED]> 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

Re: [BUGS] Large join runs out of memory in 8.1

2006-03-14 Thread Joe Sunday
On Tue, Mar 14, 2006 at 11:13:38PM -0500, Tom Lane wrote: > Joe Sunday <[EMAIL PROTECTED]> 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

Re: [BUGS] Large join runs out of memory in 8.1

2006-03-14 Thread Tom Lane
Joe Sunday <[EMAIL PROTECTED]> 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

Re: [BUGS] Large join runs out of memory in 8.1

2006-03-14 Thread Joe Sunday
On Tue, Mar 14, 2006 at 03:56:51PM -0500, Tom Lane wrote: > Joe Sunday <[EMAIL PROTECTED]> writes: > > 8.1 grows until it uses about 4 GB, at which point it dies with the > > following error: > > ERROR: out of memory > > DETAIL: Failed on request of size 8224. > > This error should result in du

Re: [BUGS] Large join runs out of memory in 8.1

2006-03-14 Thread Tom Lane
Joe Sunday <[EMAIL PROTECTED]> writes: > 8.1 grows until it uses about 4 GB, at which point it dies with the > following error: > ERROR: out of memory > DETAIL: Failed on request of size 8224. This error should result in dumping a list of per-context memory usage into the postmaster log ... coul