From: | "Mark Woodward" <pgsql(at)mohawksoft(dot)com> |
---|---|
To: | "Andrew Dunstan" <andrew(at)dunslane(dot)net> |
Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Query Failed, out of memory |
Date: | 2006-10-05 17:03:19 |
Message-ID: | 18040.24.91.171.78.1160067799.squirrel@mail.mohawksoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Tom Lane wrote:
>> "Mark Woodward" <pgsql(at)mohawksoft(dot)com> writes:
>>
>>> psql -p 5435 -U pgsql -t -A -c "select client, item, rating, day from
>>> ratings order by client" netflix > netflix.txt
>>>
>>
>> FWIW, there's a feature in CVS HEAD to instruct psql to try to use a
>> cursor to break up huge query results like this. For the moment I'd
>> suggest using COPY instead.
>>
>>
>>
>
> but COPY doesn't guarantee any order.
>
> BTW, I just this morning discovered the hard way that our linux boxes
> didn't have strict memory allocation turned on, and then went and set
> it. I'd advise Mark to do the same, if he hasn't already.
>
Yea, I've been toying with the idea of that setting lately, I can't for
the life of me understand why it isn't the default behavior.
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2006-10-05 17:40:36 | Win XP SP2 SMP locking (8.1.4) |
Previous Message | Mark Woodward | 2006-10-05 16:55:51 | Re: Query Failed, out of memory |