Re: Large Objects

The only thing that concerns me about using the filesystem is what
happens if the user deletes an image from the FS, the image table would
be in an inconsistent state. Still trying to think of an elegant
solution to solve that.

On 木, 2002-06-27 at 00:50, Karel Zak wrote:
> 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(at)zf(dot)jcu(dot)cz>
> http://home.zf.jcu.cz/~zakkr/
>
> C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz