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 <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
