From: | Kirk Wythers <kwythers(at)umn(dot)edu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Gábriel Ákos <akos(dot)gabriel(at)i-logic(dot)hu>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: trouble with a join on OS X |
Date: | 2007-02-02 16:05:29 |
Message-ID: | 079F46AF-287E-4FC5-818E-B593C8C73D06@umn.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Feb 2, 2007, at 9:46 AM, Tom Lane wrote:
> =?ISO-8859-1?Q?G=E1briel_=C1kos?= <akos(dot)gabriel(at)i-logic(dot)hu> writes:
>> Richard Huxton wrote:
>>> Kirk Wythers wrote:
>>>> I am trying to do fairly simple joins on climate databases that
>>>> should
>>>> return ~ 7 million rows of data.
>
>> If you look at the message carefully, it looks like (for me) that the
>> client is running out of memory. Can't allocate that 8,4MB :)
>
> Right, the join result doesn't fit in the client's memory limit.
> This is not too surprising, as the out-of-the-box ulimit settings
> on Tiger appear to be
>
> $ ulimit -a
> core file size (blocks, -c) 0
> data seg size (kbytes, -d) 6144
> file size (blocks, -f) unlimited
> max locked memory (kbytes, -l) unlimited
> max memory size (kbytes, -m) unlimited
> open files (-n) 256
> pipe size (512 bytes, -p) 1
> stack size (kbytes, -s) 8192
> cpu time (seconds, -t) unlimited
> max user processes (-u) 266
> virtual memory (kbytes, -v) unlimited
> $
>
> 6 meg of memory isn't gonna hold 7 million rows ... so either raise
> "ulimit -d" (quite a lot) or else use a cursor to fetch the result
> in segments.
>
Thanks Tom... Any suggestions as to how much to raise ulimit -d? And
how to raise ulimit -d?
From | Date | Subject | |
---|---|---|---|
Next Message | Steinar H. Gunderson | 2007-02-02 16:09:03 | Re: trouble with a join on OS X |
Previous Message | Kirk Wythers | 2007-02-02 15:59:38 | Re: trouble with a join on OS X |