| 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: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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 | Date | Subject | |
|---|---|---|---|
| Next Message | Rick Gigger | 2003-02-12 00:25:29 | Re: [HACKERS] Changing the default configuration (was Re: |
| Previous Message | Paul Ramsey | 2003-02-11 23:46:28 | Maximum Size for Large Object / TOASTed Object |