Re: out of memory error

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