Re: Large join runs out of memory in 8.1

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Large join runs out of memory in 8.1
Дата
Msg-id 28378.1142446241@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Large join runs out of memory in 8.1  (Joe Sunday <sunday@csh.rit.edu>)
Ответы Re: Large join runs out of memory in 8.1  (Joe Sunday <sunday@csh.rit.edu>)
Список pgsql-bugs
Joe Sunday <sunday@csh.rit.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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Joe Sunday
Дата:
Сообщение: Re: Large join runs out of memory in 8.1
Следующее
От: Joe Sunday
Дата:
Сообщение: Re: Large join runs out of memory in 8.1