Answer the question
In order to leave comments, you need to log in
Is it worth migrating a table from PostgreSQL to NoSQL or another solution?
Good day,
There is a PostgreSQL database in which there is a table where now there are 9 thousand rows and 150 columns + it is constantly updated (but not very fast). In many lines, the cells are occupied by the value "NULL". There are three other tables associated with this table.
I don't really like it, since the information from this table is requested a very large number of times.
Answer the question
In order to leave comments, you need to log in
Before migrating data to NoSQL, try using a single JSONB field in PostgreSQL to store the data for those 150 columns. If the result suits, there is no point in moving.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question