haukinger@xxxxxx 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
