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 18:10:41
Message-ID: 28378.1142446241@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 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mattias Kregert 2006-03-15 18:13:39 BUG #2319: psql utf8/latin1 client_encoding bug when using '-c'
Previous Message Joe Sunday 2006-03-15 17:48:59 Re: Large join runs out of memory in 8.1