Re: TOAST and TEXT

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