Re: getBinaryStream and OutOfMemoryException

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: getBinaryStream and OutOfMemoryException
Дата
Msg-id 42C14B45.8000500@opencloud.com
обсуждение исходный текст
Ответ на getBinaryStream and OutOfMemoryException  (Jesper Thorhauge <jth@conzentrate.com>)
Ответы Re: getBinaryStream and OutOfMemoryException  (Jesper Thorhauge <jth@conzentrate.com>)
Список 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 по дате отправления:

Предыдущее
От: Jesper Thorhauge
Дата:
Сообщение: getBinaryStream and OutOfMemoryException
Следующее
От: Jesper Thorhauge
Дата:
Сообщение: Re: getBinaryStream and OutOfMemoryException