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

Re: Resultset holdability

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Geert Bevin <gbevin(at)uwyn(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Resultset holdability
Date: 2005-10-21 21:33:53
Message-ID: 43595EC1.90800@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Oliver Jowett wrote:
> Geert Bevin wrote:
> 
>> 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?
> 
> 
> What driver version are you using?
> What server version are you using?
> Have you turned autocommit off?

One more:

Is the statement/resultset TYPE_FORWARD_ONLY?

-O

In response to

Responses

pgsql-jdbc by date

Next:From: Geert BevinDate: 2005-10-21 21:57:44
Subject: Re: Resultset holdability
Previous:From: Geert BevinDate: 2005-10-21 21:33:08
Subject: Re: Resultset holdability

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