Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Although the field length is limited to 1GB, is there a row size
> limit?
Sure. 1Gb per field (hard limit) times 1600 fields (also hard limit).
In practice less, since TOAST pointers are 20bytes each at present,
meaning you can't have more than BLCKSZ/20 toasted fields in one row.
Whether this has anything to do with real applications is debatable,
however. I find it hard to visualize a table design that needs several
hundred columns that *all* need to be GB-sized.
regards, tom lane