Create table as select ... Order by ... Copy to ...
- Luke Msg is shrt cuz m on ma treo -----Original Message----- From: Andrew Dunstan [mailto:[EMAIL PROTECTED] Sent: Thursday, October 05, 2006 12:51 PM Eastern Standard Time To: Tom Lane Cc: Mark Woodward; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Query Failed, out of memory 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. cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster