Re: Out of memory exception - Mailing list pgsql-jdbc

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