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