I have performance problems with scrollable result sets, it looks like
all rows are fetched despite ResultSet.setFetchSize(). its major
problem with sets about 11m rows in size and query execution takes a long
time, so limit/offset can not be used..
any known workarounds? I am porting oracle app to pgsql.