Postgres Pro
Downloads
Home   >   mailing lists

Re: Maximum Size for Large Object / TOASTed Object - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Maximum Size for Large Object / TOASTed Object
Date
Msg-id 1273.1045031010@sss.pgh.pa.us
Whole thread Raw
In response to Maximum Size for Large Object / TOASTed Object  (Paul Ramsey <pramsey@refractions.net>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy]
Next
From: ow
Date:
Subject: Re: [pgsql-advocacy] PostgreSQL Benchmarks