Re: More then 1600 columns?

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: More then 1600 columns?
Дата
Msg-id 4CDCDB94.2080300@hogranch.com
обсуждение исходный текст
Ответ на Re: More then 1600 columns?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: More then 1600 columns?  (Dmitriy Igrishin <dmitigr@gmail.com>)
Список pgsql-general
On 11/11/10 9:24 PM, Tom Lane wrote:
> "Mark Mitchell"<mmitchell@riccagroup.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.



В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: More then 1600 columns?
Следующее
От: Dmitriy Igrishin
Дата:
Сообщение: Re: More then 1600 columns?