| From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
|---|---|
| To: | Aleksey Demakov <avd(at)gcom(dot)ru> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: [INTERFACES] large objects |
| Date: | 1998-07-27 09:48:47 |
| Message-ID: | Pine.LNX.3.96.980727104640.934F-100000@maidast.retep.org.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
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(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)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(at)maidstone(dot)gov(dot)uk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cyril Ferrand | 1998-07-27 09:59:25 | Re: [INTERFACES] JDBC compile error |
| Previous Message | Peter T Mount | 1998-07-27 09:46:04 | Re: [INTERFACES] simple JDBC --> can't get started |