Tom,
I tried ulimit -d 614400, but the query ended with the same error. I
thought then that the message:
psql(21522) malloc: *** vm_allocate(size=8421376) failed (error code=3)
psql(21522) malloc: *** error: can't allocate region
psql(21522) malloc: *** set a breakpoint in szone_error to debug
out of memory for query result
was telling me that I needed 841376 for the querry, so I tied bumping
ulimit -d up another 10 to 6244000. However, that attempt gave the
error:
truffula:~ kwythers$ ulimit -d 6144000
-bash: ulimit: data seg size: cannot modify limit: Operation not
permitted
So I tried re-setting ulimit -d back to 6144, which worked, but now I
can not seem to get ulimit -d to change again. It will not even allow
ulimit -d 614400 (even though that worked a second ago). This seems
very odd.
On Feb 2, 2007, at 10:11 AM, Tom Lane wrote:
"Steinar H. Gunderson" <sgunderson@xxxxxxxxxxx> writes:
On Fri, Feb 02, 2007 at 10:05:29AM -0600, Kirk Wythers wrote:
Thanks Tom... Any suggestions as to how much to raise ulimit -d? And
how to raise ulimit -d?
Try multiplying it by 100 for a start:
ulimit -d 614400
Or just "ulimit -d unlimited"
regards, tom lane
---------------------------(end of
broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
