Re: [GENERAL] CLOB & BLOB limitations in PostgreSQL

Bruce Momjian <bruce(at)momjian(dot)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