Maximum Size for Large Object / TOASTed Object

Lists: pgsql-hackers
From: Paul Ramsey <pramsey(at)refractions(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Maximum Size for Large Object / TOASTed Object
Date: 2003-02-11 23:46:28
Message-ID: 3E498B54.7040508@refractions.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi All,

What is the maximum size a large object can be in PostgreSQL?
What is the maximum size a TOASTed object can be in PostgreSQL?

The "PostgreSQL Limitations" page says the maximum size of a "field" is
1 Gb, but does a large object constitute a field? :)

Thanks,
Paul

--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey(at)refractions(dot)net
| Phone: (250) 885-0632
\_

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: Paul Ramsey <pramsey(at)refractions(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Maximum Size for Large Object / TOASTed Object
Date: 2003-02-11 23:55:37
Message-ID: Pine.LNX.4.21.0302112353400.2660-100000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Tue, 11 Feb 2003, Paul Ramsey wrote:

> Hi All,
>
> What is the maximum size a large object can be in PostgreSQL?
> What is the maximum size a TOASTed object can be in PostgreSQL?
>
> The "PostgreSQL Limitations" page says the maximum size of a "field" is
> 1 Gb, but does a large object constitute a field? :)
>
> Thanks,
> Paul

I don't know but large objects are stored in the filesystem so I presume any
limit is going to apply there. A large object isn't a field, the large object
id can, and very probably should, be stored in one though.

--
Nigel J. Andrews

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul Ramsey <pramsey(at)refractions(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Maximum Size for Large Object / TOASTed Object
Date: 2003-02-12 06:23:30
Message-ID: 1273.1045031010@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Paul Ramsey <pramsey(at)refractions(dot)net> writes:
> What is the maximum size a large object can be in PostgreSQL?
> What is the maximum size a TOASTed object can be in PostgreSQL?

TOASTed fields max out at 1Gb. Large objects max out at either 2 or 4 Gb
... I'm not sure whether we consistently use signed or unsigned
arithmetic for them. (Probably they *should* max out at 4Gb, and if you
find any places that fail over 2Gb, those are bugs for which patches
will be gladly accepted.)

regards, tom lane