| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Travis Harris <trex005(dot)junk(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: blob storage |
| Date: | 2005-04-26 22:14:46 |
| Message-ID: | 14716.1114553686@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:
> On Tue, Apr 26, 2005 at 03:41:28PM -0500, Scott Marlowe wrote:
>> If you store them as large objects, they will each get their own file.
> Huh, no, they won't. They will be stored in the pg_largeobject table.
> It's been quite a while since they are not stored in separate files;
> though they keep the POSIX-filesystem-like semantics.
But in any case, the platform limit on file size is irrelevant because
we split tables into 1GB-size files. The effective limit is 16TB IIRC
(see the FAQ for the correct number).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Robinson | 2005-04-27 01:43:06 | Re: Performance difference between ANY and IN, also array syntax |
| Previous Message | Bart Grantham | 2005-04-26 22:12:15 | Performance difference between ANY and IN, also array syntax |