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