| From: | Peter Mount <peter(at)retep(dot)org(dot)uk> |
|---|---|
| To: | Adam Ruth <aruth(at)intercation(dot)com> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: To BLOB Or Not To BLOB |
| Date: | 2000-04-17 19:29:06 |
| Message-ID: | Pine.LNX.4.10.10004172028160.6375-100000@maidast.retep.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jurgen Defurne | 2000-04-17 19:33:44 | Re: Postgresqlism & Vacuum? |
| Previous Message | Hal Snyder | 2000-04-17 19:10:05 | excell to postgres |