Large Objects

From: haukinger(at)gmx(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: Large Objects
Date: 2007-02-20 17:02:06
Message-ID: 20070220170206.187890@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Fitzpatrick 2007-02-20 17:26:02 Complex search advice?
Previous Message Stefan Kaltenbrunner 2007-02-20 16:52:30 Re: Warning "TupleDesc reference leak"