Re: where does postgres keep the query result until it is returned? - Mailing list pgsql-general

From Willy-Bas Loos
Subject Re: where does postgres keep the query result until it is returned?
Date
Msg-id AANLkTimYQnqEW5yfJZsK6bSKcOMNdi18pQ2L+FH0Pbod@mail.gmail.com
Whole thread Raw
In response to Re: where does postgres keep the query result until it is returned?  (Willy-Bas Loos <willybas@gmail.com>)
List pgsql-general
On Thu, Sep 30, 2010 at 7:29 PM, Willy-Bas Loos <willybas@gmail.com> wrote:
> 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.

On second thought, that helps for the scenario where your client
looses connection or otherwise stops functioning before it has
received the whole query result, it isn't really related to the topic.
--
"Patriotism is the conviction that your country is superior to all
others because you were born in it." -- George Bernard Shaw

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Missing path in pg_config
Next
From: Vincenzo Romano
Date:
Subject: Re: [9.0] On temporary tables