>negora <negora@xxxxxxxxxx> wrote: > I even might return the entire result to my external Java > application You are probably going to want to configure it to use a cursor, at least if the result set is large (i.e., too big to cache the entire result set in memory before you read the first row). Read this over carefully: http://jdbc.postgresql.org/documentation/84/query.html#query-with-cursor You don't have to use a Java cursor or do anything procedurally there, but a PostgreSQL cursor is the only way to stream the data to the application on demand (ResultSet.next), rather than pushing it all there during the Statement.execute(). -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
