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

From Nigel J. Andrews
Subject Re: Maximum Size for Large Object / TOASTed Object
Date
Msg-id Pine.LNX.4.21.0302112353400.2660-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to Maximum Size for Large Object / TOASTed Object  (Paul Ramsey <pramsey@refractions.net>)
List 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



pgsql-hackers by date:

Previous
From: Paul Ramsey
Date:
Subject: Maximum Size for Large Object / TOASTed Object
Next
From: "Rick Gigger"
Date:
Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy]