Re: getBinaryStream and OutOfMemoryException - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: getBinaryStream and OutOfMemoryException
Date
Msg-id 42C14B45.8000500@opencloud.com
Whole thread Raw
In response to getBinaryStream and OutOfMemoryException  (Jesper Thorhauge <jth@conzentrate.com>)
Responses Re: getBinaryStream and OutOfMemoryException  (Jesper Thorhauge <jth@conzentrate.com>)
List pgsql-jdbc
Jesper Thorhauge wrote:
> Looking into the cvs
> checkout from
> 22-05-2005, it really seems to me that getBinaryStream is nothing more
> than a
> getBytes ...??

Correct. The current frontend/backend protocol doesn't really let us do
this differently, at least for bytea columns. It could be made more
memory-efficient (e.g. by using the binary result format rather than the
current text format) but the driver still has to pull the entire column
value across the wire at the time the row is returned.

Another approach would be to write large column values to disk, but
noone's written the code to do that yet; it also has some other problems
such as: what if you are running in an environment where you don't have
access to the disk?

-O

pgsql-jdbc by date:

Previous
From: Jesper Thorhauge
Date:
Subject: getBinaryStream and OutOfMemoryException
Next
From: Jesper Thorhauge
Date:
Subject: Re: getBinaryStream and OutOfMemoryException