Postgres Pro
Downloads
Home   >   mailing lists

Thread: BYTEA with large files leads to OutOfMemory

BYTEA with large files leads to OutOfMemory

From
Fuchs Clemens
Date:

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?

thanks,
Clemens

Re: BYTEA with large files leads to OutOfMemory

From
Paul Thomas
Date:
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   |
+------------------------------+---------------------------------------------+

Re: BYTEA with large files leads to OutOfMemory

From
Fuchs Clemens
Date:

Thanks,

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

Clemens

-----Ursprüngliche Nachricht-----
Von: Paul Thomas [mailto:paul@tmsl.demon.co.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   |
+------------------------------+---------------------------------------------+