Re: out of memory for query result

Sven Willenberger <sven@dmv.com> writes:

> On Sat, 2006-04-22 at 15:08 -0400, Tom Lane wrote:
>> Francisco Reyes <lists@stringsutils.com> writes:
>> > What resource do I need to increase to avoid the error above?
>>
>> Process memory allowed to the client; this is not a server-side error.
>>
>
> I am experiencing an "out of memory" situation as well on large query
> results, even with allowing 2G process memory to the client:

The server settings don't have anything to do with this problem.  The
client is trying to read the entire result set into memory before it
writes it out (that's just the way it works).  You can do it in
smaller chunks by using a cursor with DECLARE and FETCH.

-Doug