Hi, I just spent some time trying to figure out why java was caching a huge result set in memory while i was using a cursor in jooq.
It looks like that to get CURSORs to work correctly with PostgreSQL, one needs to call "setFetchSize" with something > 0 on the JDBC statement: http://jdbc.postgresql.org/documentation/head/query.html#query-with-cursor . Is there a way to do this from/with jOOQ? Sander
