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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
