Re: To BLOB Or Not To BLOB

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(at)retep(dot)org(dot)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