Postgres Pro
Downloads
Home   >   mailing lists

Large Objects - Mailing list pgsql-general

From haukinger@gmx.de
Subject Large Objects
Date
Msg-id 20070220170206.187890@gmx.net
Whole thread Raw
Responses Re: Large Objects  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
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
ableto 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 ? 

Thanks a lot in advance !

Haukinger
--
"Feel free" - 5 GB Mailbox, 50 FreeSMS/Monat ...
Jetzt GMX ProMail testen: www.gmx.net/de/go/mailfooter/promail-out

pgsql-general by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: complex referential integrity constraints
Next
From: Jim Nasby
Date:
Subject: Re: what compression is used in on disk bitmap index implementation