Where does postgres keep the query result until it is returned? In the shared_buffers? Or in extra memory that was not previously allocated, or something else?
What if the query result becomes very large, so that it won't fit into memory?
cheers,
WBL
-- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw