Bruce Momjian <br...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
