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
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 |