out of memory error

Поиск
Список
Период
Сортировка
От Wm.A.Stafford
Тема out of memory error
Дата
Msg-id 45C3913A.40607@marine.rutgers.edu
обсуждение исходный текст
Ответы Re: out of memory error
Список 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



В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: JDBC and arrays
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: out of memory error