On 4/24/19 4:17 PM, pabloa98 wrote: > 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.
As everyone else has mentioned, your use case sounds like arrays are appropriate. Note that PostgreSQL supports 2 dimensional (actually more than 2d if you wanted) arrays which are essentially perfect for representing a matrix.
If this works for your data model it will likely save a ton of storage space and perform much better than alternatives.
FWIW, if you are needing to do matrix math, you might want to look into PL/R (https://github.com/postgres-plr/plr) as it supports 2d arrays as arguments which are converted directly into R matrices.
I don't know for sure but likely PL/Python could be used to process matrices as well.
HTH,
Joe
-- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development