| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | pabloa98 <pabloa98(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: how to add more than 1600 columns in a table? |
| Date: | 2019-04-24 20:22:34 |
| Message-ID: | 68c9b875-e0d8-168d-a587-e85fb9e3f5e5@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 4/24/19 1: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.
Not sure how hit 1600 column limit = having 2400 columns?
Off hand I would say you are using the wrong tool for the job. More
information on what you trying to achieve might help get you to the
correct tool.
>
> 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.
>
> Pablo
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2019-04-24 20:22:52 | Re: how to add more than 1600 columns in a table? |
| Previous Message | Thomas Kellerer | 2019-04-24 20:18:49 | Re: how to add more than 1600 columns in a table? |