Re: how to add more than 1600 columns in a table?
| От | pabloa98 |
|---|---|
| Тема | Re: how to add more than 1600 columns in a table? |
| Дата | |
| Msg-id | CAEjudX5GTFwc1HPn5n1CuZTpYFvYAO61=LxPkUWov9yJFCVVNQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: how to add more than 1600 columns in a table? (Ron <ronljohnsonjr@gmail.com>) |
| Список | pgsql-general |
if there is some no-SQL database supporting ACID + generic queries like a SQL database, I would consider it.
However, the column limit is the problem, no the database. 1200 cols are reasonable for standard problems. Having a Postgresql supporting thousands of columns will be useful in Machine Learning and similar domains.
Pablo
On Wed, Apr 24, 2019 at 1:23 PM Ron <ronljohnsonjr@gmail.com> wrote:
On 4/24/19 3:17 PM, pabloa98 wrote:
> Hello
>
> Sadly today we hit the 1600 columns limit of Postgresql 11.
>
> How could we add more columns?
>
> Note: Tables are OK. We truly have 2400 columns now. Each column
> represents a value in a matrix.
>
> We have millions of rows so I would prefer not to transpose each row to
> (x, y, column_value) triplets because it will make all our code more
> difficult of what it is.
>
> Any help, very appreciated.
Is a relational database the proper tool for the job?
--
Angular momentum makes the world go 'round.
В списке pgsql-general по дате отправления: