From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
---|---|
To: | Fuchs Clemens <clemens(dot)fuchs(at)siemens(dot)com> |
Cc: | "pgsql-jdbc (at) postgresql (dot) org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: BYTEA with large files leads to OutOfMemory |
Date: | 2004-03-17 18:07:38 |
Message-ID: | 20040317180738.C5355@bacon |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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 |
+------------------------------+---------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | as1024 | 2004-03-18 01:09:14 | textfiles |
Previous Message | Glenn Holmer | 2004-03-17 17:05:07 | Re: updatable result sets |