On Mon, 18 Jul 2005, Kevin Grittner wrote:
> Are you saying that if I execute a statement like:
> select * from "TableWithHundredsOfMillionsOfRows"
> that the entire table will be copied to a result set before returning
> the first row? Is this result set built in RAM on the server side?
>
> I am interested primarily in the behavior under JDBC, although psql is
> also significant.
http://jdbc.postgresql.org/documentation/80/query.html#query-with-cursor
Kris Jurka
