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@bigfoot.com> 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
>