I
I
Ivan Stroykin2017-05-18 01:01:50
Database
Ivan Stroykin, 2017-05-18 01:01:50

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

1 answer(s)
A
Alexander Shelemetiev, 2017-05-18
@StivinKing

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 question

Ask a Question

731 491 924 answers to any question