Skip site navigation (1) Skip section navigation (2)

Resultset holdability

From: Geert Bevin <gbevin(at)uwyn(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Resultset holdability
Date: 2005-10-21 15:46:37
Message-ID: D38F6D5C-FEDE-4ABB-9D1B-B09BC9B451E9@uwyn.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hello,

I have a resultset that has many rows with bytea data.

It looks like me that when I iterate through the rows, the previous  
rows are only garbage collectable when the resultset is closed, even  
if I setup the statement like this:
statement.setFetchDirection(ResultSet.FETCH_FORWARD);
statement.setFetchSize(1);

Since it's bytea data, this fills up the memory very quickly. Any  
thoughts on how to reduce this memory overhead and have the resultset  
discard any previously fetched data?

Thanks for the help,

Geert

--
Geert Bevin                       Uwyn bvba
"Use what you need"               Avenue de Scailmont 34
http://www.uwyn.com               7170 Manage, Belgium
gbevin[remove] at uwyn dot com    Tel +32 64 84 80 03

PGP Fingerprint : 4E21 6399 CD9E A384 6619  719A C8F4 D40D 309F D6A9
Public PGP key  : available at servers pgp.mit.edu, wwwkeys.pgp.net



Responses

pgsql-jdbc by date

Next:From: Sergei RogovskiyDate: 2005-10-21 15:57:08
Subject: Speed up fixes
Previous:From: Dave CramerDate: 2005-10-20 22:28:40
Subject: bug with pginterval

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group