Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group