On 11/11/10 9:24 PM, Tom Lane wrote:
> "Mark Mitchell"<mmitchell(at)riccagroup(dot)com> writes:
>> Is there are hard limit of 1600 that you cannot get around?
> Yes.
>
> Generally, wanting more than a few dozen columns is a good sign that you
> need to rethink your schema design. What are you trying to accomplish
> exactly?
>
indeed. I'd say a good read on 'data normalization' and the Third
Normal Form would be in order.
relational databases are *not* spreadsheets (and, for that matter,
spreadsheets make lousy relational databases)
if these 1600+ elements come from an ORM, you probably need to rethink
your object model, as no sane object class should have that many members.
In response to
Responses
pgsql-general by date
| Next: | From: Dmitriy Igrishin | Date: 2010-11-12 07:17:50 |
| Subject: Re: More then 1600 columns? |
| Previous: | From: Tom Lane | Date: 2010-11-12 05:24:11 |
| Subject: Re: More then 1600 columns? |