Re: Memory exhausted in AllocSetReAlloc - Mailing list pgsql-general

From Tom Lane
Subject Re: Memory exhausted in AllocSetReAlloc
Date
Msg-id 6752.1005754208@sss.pgh.pa.us
Whole thread Raw
In response to Re: Memory exhausted in AllocSetReAlloc  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I said:
> More to the point, what have you got SORT_MEM set to?

Or maybe that's not the point.  A quick look through the sources didn't
turn up any repalloc calls that look like they could make requests that
large (at least not before you'd run out of memory from other causes).

Could you attach to the backend process with gdb, set a breakpoint
at elog, and get a backtrace, so we can see where the oversize
request is coming from?

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: transitioning from MS SQL Server to Postgres
Next
From: "PIPER,JIM (A-SantaClara,ex1)"
Date:
Subject: Re: MS Client ODBC question