Re: TOAST and TEXT

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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.

I read this as 409GB with 8k pages.

> 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.

Yes, that just makes my head hurt. Easier to just say "unlimited" and
limited by your computer's memory/disk.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026