On 11/04/2014 16:45, Jack.O'Sullivan@xxxxxxxxxxxx wrote: > With point two, does this mean that any table with a bytea datatype is > limited to 4 billion rows (which would seem in conflict with the > "unlimited rows" shown by http://www.postgresql.org/about)? If we had > rows where the bytea was a "null" entry would they contribute towards > this total or is it 4 billion non-null entries? This seems strange. A core developer should confirm this but it doesn't make much sense - "bytea" fields are stored the same as "text" fields (including varchar etc), i.e. the "varlena" internal representation, so having the limit you are talking about would mean that any non-trivial table with long-ish text fields would be limited to 2^32 entries...
Attachment:
signature.asc
Description: OpenPGP digital signature
