Re: Beyond the 1600 columns limit on windows

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Beyond the 1600 columns limit on windows
Дата
Msg-id 5432.1131461788@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Beyond the 1600 columns limit on windows  ("Evandro's mailing lists (Please, don't send personal messages to this address)" <listasjr@gmail.com>)
Список pgsql-general
"Evandro's mailing lists (Please, don't send personal messages to this address)" <listasjr@gmail.com> writes:
> I'm doing a PhD in data mining and I need more than 1600 columns.

I don't think so --- consider redesigning your data model instead.
For instance, maybe you could combine similar columns into an array.
Or split the table into an m:n linking structure.  Even coming close
to that implementation limit suggests bad SQL design; if we thought
it was a realistic problem we would have increased it long ago...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Perl::DBI and interval syntax [side question]
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Detect Locked Row Without Blocking