Re: Help with retrieving large results sets and memory usage. - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Help with retrieving large results sets and memory usage.
Date
Msg-id 19301.1061261406@sss.pgh.pa.us
Whole thread Raw
In response to Help with retrieving large results sets and memory usage.  (Peter.Rupp@ual.com)
List pgsql-interfaces
Peter.Rupp@ual.com writes:
> When using either interface, I notice that when I select rows from a
> table, it appears that the client interface retrieves  the entire
> results set at once...and loads it into memory on the client machine.   

The standard answer is to use a cursor and FETCH a few rows at a time.

>     Do you folks publish the network symantics and protocols used to
> make sql requests and retrieve their results?

http://developer.postgresql.org/docs/postgres/protocol.html
        regards, tom lane


pgsql-interfaces by date:

Previous
From: Peter.Rupp@ual.com
Date:
Subject: Help with retrieving large results sets and memory usage.
Next
From: Ryan Mooney
Date:
Subject: ECPG Connect user :variable problem