Re: blob storage - Mailing list pgsql-general

From Tom Lane
Subject Re: blob storage
Date
Msg-id 14716.1114553686@sss.pgh.pa.us
Whole thread Raw
In response to Re: blob storage  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Alvaro Herrera <alvherre@dcc.uchile.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

pgsql-general by date:

Previous
From: Bart Grantham
Date:
Subject: Performance difference between ANY and IN, also array syntax
Next
From: Typing80wpm@aol.com
Date:
Subject: www.thekompany.com rekall