Maximum number of columns in a table - Mailing list pgsql-general

From Gerry Scales
Subject Maximum number of columns in a table
Date
Msg-id E64F4413DFD24031873D223A3093105C@GPS071
Whole thread Raw
Responses Re: Maximum number of columns in a table
Re: Maximum number of columns in a table
List pgsql-general
The FAQs state "Maximum number of columns in a table? 250-1600 depending on column types".
 
Is there a location which gives instructions for calculating whether a number of columns of different types can be accommodated?
 
I have a situation where I need to load tables from another database which may theoretically contain up to 1000 columns per table and this information will determine whether I need to rebuild PostgreSQL with a larger blocksize.  Splitting into multiple tables is not always an easy option.
 
Many thanks
 
Gerry 



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4001 (20090411) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Connect without specifying a database?
Next
From: Martin Gainty
Date:
Subject: Re: Maximum number of columns in a table