木, 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 > 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)