From: | Kirk Wythers <kwythers(at)umn(dot)edu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>, 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 18:06:54 |
Message-ID: | 482ECA0F-24CD-4B4C-84BE-F6F1CA89FAD6@umn.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
At this point there are no silly questions. But I am running the
query under the shell session that I adjusted. I did discover that
ulimit -d only changes the shell session that you issue the command
in. So I changed ulimit -d to unlimited, connected to the db with
psql db_name, then ran the select command (all in the same shell).
On Feb 2, 2007, at 11:59 AM, Tom Lane wrote:
> Kirk Wythers <kwythers(at)umn(dot)edu> writes:
>> However, setting ulimit to unlimited does not seem to solve the
>> issue. Output from ulimit -a is:
>
> Possibly a silly question, but you are running the client code
> under the
> shell session that you adjusted ulimit for, yes?
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Frost | 2007-02-02 18:16:23 | Re: drive configuration for a new server |
Previous Message | Tom Lane | 2007-02-02 17:59:39 | Re: trouble with a join on OS X |