| From: | "Gerry Scales" <gerry(at)tbstbs(dot)net> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Maximum number of columns in a table |
| Date: | 2009-04-11 19:33:35 |
| Message-ID: | E64F4413DFD24031873D223A3093105C@GPS071 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Gainty | 2009-04-11 20:29:09 | Re: Maximum number of columns in a table |
| Previous Message | Tom Lane | 2009-04-11 18:25:05 | Re: Connect without specifying a database? |