Re: out of memory error

From: Kris Jurka <books(at)ejurka(dot)com>
To: "Wm(dot)A(dot)Stafford" <stafford(at)marine(dot)rutgers(dot)edu>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: out of memory error
Date: 2007-02-02 20:04:41
Message-ID: Pine.BSO.4.64.0702021503230.26922@leary2.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Robert Spies 2007-02-02 23:34:05 Jdbc3PoolingDataSource ssl question
Previous Message Wm.A.Stafford 2007-02-02 19:30:02 out of memory error