Skip site navigation (1) Skip section navigation (2)

Re: BYTEA with large files leads to OutOfMemory

From: Fuchs Clemens <clemens(dot)fuchs(at)siemens(dot)com>
To: "'Paul Thomas'" <paul(at)tmsl(dot)demon(dot)co(dot)uk>
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-19 05:44:17
Message-ID: 9DDD01E6B277D511B22300A0C9EEE776025D4F09@LNZP106A (view raw or flat)
Thread:
Lists: pgsql-jdbc
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   |
+------------------------------+--------------------------------------------
-+

pgsql-jdbc by date

Next:From: Denis KhabasDate: 2004-03-19 16:07:15
Subject: Bad timestamp external representation
Previous:From: Markus SchaberDate: 2004-03-18 23:26:48
Subject: Re: Register arbitrary types Framework

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group