BYTEA with large files leads to OutOfMemory - Mailing list pgsql-jdbc

From Fuchs Clemens
Subject BYTEA with large files leads to OutOfMemory
Date
Msg-id 9DDD01E6B277D511B22300A0C9EEE776025D4EFD@LNZP106A
Whole thread Raw
Responses Re: BYTEA with large files leads to OutOfMemory  (Paul Thomas <paul@tmsl.demon.co.uk>)
List pgsql-jdbc

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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Register arbitrary types Framework
Next
From: Glenn Holmer
Date:
Subject: updatable result sets