Re: BYTEA with large files leads to OutOfMemory

Thanks,

I switched to the Large Object Interface and now it works fine.

Clemens

-----Ursprüngliche Nachricht-----
Von: Paul Thomas [mailto:paul(at)tmsl(dot)demon(dot)co(dot)uk]
Gesendet: Mittwoch, 17. März 2004 19:08
An: Fuchs Clemens
Cc: pgsql-jdbc @ postgresql . org
Betreff: Re: [JDBC] BYTEA with large files leads to OutOfMemory

On 17/03/2004 15:19 Fuchs Clemens wrote:
> Hi,
>
> I'm working on a project, which has to deal with files being uploaded to
> the
> DB. I created a table using the BYTEA datataype and uploading small files
> works great. But with larger files - I tested with 2.5 MB file - the
> memory
> consumption raises incredibly and leads to a OutOfMemory exception.
>
> I noticed several discussions about this topic, but found no solution.
>
> Can someone help me?

I think you've got 2 options:

1) increase the amount of memory for the JVM

2) use the Large Object interface instead of bytea.

HTH

--
Paul Thomas
+------------------------------+--------------------------------------------
-+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+--------------------------------------------
-+