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@refractions.net
      | Phone: (250) 885-0632
      \_


Tue, 11 Feb 2003 15:46:28 -0800
Paul Ramsey <pramsey@refractions.net>
Maximum Size for Large Object / TOASTed Object
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


Tue, 11 Feb 2003 23:55:37 +0000 (GMT)
"Nigel J. Andrews" <nandrews@investsystems.co.uk>
Re: Maximum Size for Large Object / TOASTed Object
Paul Ramsey <pramsey@refractions.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

Wed, 12 Feb 2003 01:23:30 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Maximum Size for Large Object / TOASTed Object 