Re: [GENERAL] CLOB & BLOB limitations in PostgreSQL - Mailing list pgsql-hackers

Bruce Momjian <bruce@momjian.us> writes:
> Uh, I had not thought of this before but I think we need oids for toast
> storage, which would explain this wiki text:

>     https://wiki.postgresql.org/wiki/BinaryFilesInDB

>     Storing binary data using bytea or text data types 
>     Minus
>         bytea and text data type both use TOAST
>             limited to 1G per entry
>     -->     4 Billion entries per table 

> Is that correct?

No.  It'd be 4 billion toasted-out-of-line entries per table (actually,
you'd start hitting performance issues well below that, but 4G would be
the hard limit).  Small values, up to probably a KB or so, don't count
against the limit.
        regards, tom lane