Re: [HACKERS] Maximum Size for Large Object / TOASTed Object

2003-02-11 Thread Tom Lane
Paul Ramsey <[EMAIL PROTECTED]> 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

Re: [HACKERS] Maximum Size for Large Object / TOASTed Object

2003-02-11 Thread Nigel J. Andrews
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 const

[HACKERS] Maximum Size for Large Object / TOASTed Object

2003-02-11 Thread Paul Ramsey
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 -- __ /