> Tom Lane wrote: >> "Mark Woodward" <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org