Re: Large Objects

On Wed, Jun 26, 2002 at 08:56:11PM -0700, Nadim Bitar wrote:
> 
> 
> I have a collection of images that I want to store in a database. The
> collection is currently 12 GB. 

 Are you sure? Why not use standard FS and to DB store path to files? :-)

> Can anyone give me some advice or links to any documents that discuss
> the different methods to accomplish this. I already read techdocs
> documents related to large objects. I just want some advice on good ways
> to do it.

 The current PostgreSQL allows to store large data to standard table
 rows too. You needn't use large-object interface.

> The database is going to be accessed through a Servlet (JDBC).
> One thing that wasn't clear from techdocs was the disk space usage. If i
> store 12 GB in the database without deleting it from the filesystem, it
> is going to occupy another 12 GB. Is this right?

 Sure. The database use own and private dataspace and not links to
 some external files.

    Karel

-- 
 Karel Zak  
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz