> Tom Lane wrote:
>> "Mark Woodward" <pgsql@mohawksoft.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.