out of memory error

From: "Wm(dot)A(dot)Stafford" <stafford(at)marine(dot)rutgers(dot)edu>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: out of memory error
Date: 2007-02-02 19:30:02
Message-ID: 45C3913A.40607@marine.rutgers.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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.

Is there a way to eliminate these errors? I'm working on an application
that is reading a table and writing it out to a text file after
removing unprintable characters. So my program logic is dead simple:
select * from table
while ( rs.next() )
process and write;

My driver is postgresql-8.1-407.jdbc3.jar

Thanks,
-=bill

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-02-02 20:04:41 Re: out of memory error
Previous Message Kris Jurka 2007-02-02 17:00:25 Re: JDBC and arrays