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.10004172028160.6375-100000@maidast.retep.org.uk
Whole thread Raw
In response to Re: To BLOB Or Not To BLOB  ("Adam Ruth" <aruth@intercation.com>)
List pgsql-general
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.

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: Hal Snyder
Date:
Subject: excell to postgres
Next
From: Jeffrey
Date:
Subject: Re: excell to postgres