[EMAIL PROTECTED] wrote:
Hi all !
I'm working on a database that needs to handle insertion of about
100000 large objects (50..60GB) a day. It should be able to run 200
days, so it will become about 10TB eventually, mostly of 200..500KB
large objects. How does access to large objects work ? I give the oid
and get the large object... what is done internally ? How (if at all)
are the oid's indexed ?
Albe's answered your actual question, but I'd wonder if you really want
to do this?
The key question is whether you need to have the actual objects stored
under transactional control. If not, just saving them as files will
prove much more efficient.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings