Re: Help with retrieving large results sets and memory usage.

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