(unnamed)
text/plain
$BLZ(B, 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@zf.jcu.cz>
> http://home.zf.jcu.cz/~zakkr/
>
> C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)