Re: Large join runs out of memory in 8.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Sunday <sunday(at)csh(dot)rit(dot)edu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Large join runs out of memory in 8.1
Date: 2006-03-15 04:13:38
Message-ID: 16356.1142396018@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Joe Sunday <sunday(at)csh(dot)rit(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Joe Sunday 2006-03-15 04:19:14 Re: Large join runs out of memory in 8.1
Previous Message Joe Sunday 2006-03-15 00:34:42 Re: Large join runs out of memory in 8.1