Re: getBinaryStream and OutOfMemoryException - Mailing list pgsql-jdbc

From Jesper Thorhauge
Subject Re: getBinaryStream and OutOfMemoryException
Date
Msg-id 42C152EF.305@conzentrate.com
Whole thread Raw
In response to Re: getBinaryStream and OutOfMemoryException  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: getBinaryStream and OutOfMemoryException
List 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
>
>


pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: getBinaryStream and OutOfMemoryException
Next
From: Kevin Murphy
Date:
Subject: OT: easiest way to create a custom PreparedStatement class