Re: [HACKERS] Maximum row size

2007-08-13 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > ... it's kind > of pie-in-the-sky since it depends on every column being toasted (and not > compressed). It's much more normal to have some columns be quite large and > others more normal sized or different data types. Yeah. I think those numbers should

Re: [HACKERS] Maximum row size

2007-08-13 Thread Gregory Stark
Devrim GÜNDÜZ <[EMAIL PROTECTED]> writes: > What is the maximum row size for PostgreSQL? > > http://www.postgresql.org/about/ says 1.6 TB I think this comes from the maximum of 1600 columns times the maximum of 1GB per (toasted) datum. However 1600 toasted datums won't fit on an 8k page. Each