Re: [INTERFACES] large objects

On 27 Jul 1998, Aleksey Demakov wrote:

>
> I'm working on a project where there is a need to store large texts in
> a database. I thought that postgres' large object are good for this.
> But one my fellow said me that current large object implementation is
> very unefficient. So having, say, several thousands of large objects
> is impractical. Is this true?

The current implementation has a few problems.

The object is stored using a table/index pair, and takes up more disk
space than a single object.

I haven't tried several thousand objects (yet). I'm working on large
objects today, so I'll try to create a few thousand, and see what happens.

--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk