Re: Out of memory exception

Tao Yang wrote:

> Is there any possibility the postgresql jdbc driver does not handle 
> large object very well, for example, use stream for loading that big file?
> 
> Do you have any clue why we have those problems?

In brief: yes, the driver doesn't handle large binary columns very well. 
You will need 6-7 times the binary data's size in temporary heap space.

For details, take a look at:

  http://archives.postgresql.org/pgsql-jdbc/2004-04/msg00186.php
  http://archives.postgresql.org/pgsql-jdbc/2004-04/msg00128.php

-O