On Fri, 2 Feb 2007, Wm.A.Stafford wrote:
> I'm getting 'out of memory' errors when retrieving the entire contents of a
> reasonably large tables. I spent an hour or so trying all the remedies that
> showed up via Google search for 'postgresql out of memory' and nothing seemed
> to work. The two most often recommended were increasing Java heap size (I
> went up to 128m) and Statement.setFetchSize(1). I saw no significant
> difference with either of these.
Are you satisfying all of the constraints that are mentioned here:
http://jdbc.postgresql.org/documentation/head/query.html#query-with-cursor
Kris Jurka