One thing that i think works is to create a table from your results.
That is, if your result is not one big chunk in one row that won't fit
in memory, but lots of rows.
like this:
create table foo as
select <humongous query>
If you use "screen" (on linux) you can log out while your humongous
query runs on the server.
Cheers,
WBL
--
"Patriotism is the conviction that your country is superior to all
others because you were born in it." -- George Bernard Shaw