Re: To BLOB Or Not To BLOB - Mailing list pgsql-general

From Peter Mount
Subject Re: To BLOB Or Not To BLOB
Date
Msg-id Pine.LNX.4.10.10004181804300.4529-100000@maidast.retep.org.uk
Whole thread Raw
In response to Re: To BLOB Or Not To BLOB  (Lincoln Yeoh <lylyeoh@mecomb.com>)
List pgsql-general
On Tue, 18 Apr 2000, Lincoln Yeoh wrote:

> At 08:29 PM 17-04-2000 +0100, Peter Mount wrote:
> >On Mon, 17 Apr 2000, Adam Ruth wrote:
> >
> >> > I'm using Linux and ext2fs has a 2GB limit on files, and it seems like
> >> > 6.5.3 tables are stored as single files, so better not go down that path
> >> :).
> >>
> >> I'm using 6.5.2 and it will split a table among several files, so that's
> not
> >> a problem.  Though I'm not sure how BLOBs are stored since I never use
> them.
> >
> >BLOBS are currently implemented as a table/index pair, so they will split
> >at the 1Gb mark as do normal tables.
>
> Oh.. Ah well, maybe with my next version/app then. Where was it mentioned
> in the docs? Would like to look at the details.

I'm not sure about the docs, but look at the storage manager portion of
the source. It's pretty well documented in there.

Peter

--
       Peter T Mount peter@retep.org.uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf


pgsql-general by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Struggles with RC1 and RPMS
Next
From: "Michael S. Kelly"
Date:
Subject: Starting a new project, any opinions about using 7.0?