Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Sep 30, 2010 at 7:29 PM, Willy-Bas Loos <willybas@xxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux