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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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