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

Re: getBinaryStream and OutOfMemoryException

From: Jesper Thorhauge <jth(at)conzentrate(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: getBinaryStream and OutOfMemoryException
Date: 2005-06-28 13:38:55
Message-ID: 42C152EF.305@conzentrate.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Okay, thats seems like a lot!! What are the priorities about getting 
this modification into the driver? I have seen some other posts 
regarding this binaryStream / memory problem, so it seems that i'm not 
the only one :-)

Oliver Jowett wrote:

>Jesper Thorhauge wrote:
>  
>
>>Okay, thanks alot for the quick answer! I was wondering, do you know how
>>much more efficient it could be done using the binary format you are
>>mentioning? I'm especially interested in decreasing the amount of memory
>>used to get large bytea values...
>>    
>>
>
>Um, rough estimate would be about a factor of 5 (assume text
>representation of bytea averages about ~2.5 characters per raw byte, and
>characters are 16 bits on the Java side)
>
>-O
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>  
>


In response to

Responses

pgsql-jdbc by date

Next:From: Kevin MurphyDate: 2005-06-28 18:55:25
Subject: OT: easiest way to create a custom PreparedStatement class
Previous:From: Oliver JowettDate: 2005-06-28 13:29:45
Subject: Re: getBinaryStream and OutOfMemoryException

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