where does postgres keep the query result until it is returned?

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: where does postgres keep the query result until it is returned?
Date: 2010-09-17 13:00:36
Message-ID: AANLkTikgbJb4j01ONC+fuEddJ4F0ZVqOxDUut=8W2rCa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2010-09-17 13:14:57 Re: where does postgres keep the query result until it is returned?
Previous Message Steve Clark 2010-09-17 13:00:02 Re: Transposing rows and columns