Help to choose NoSQL database for project
- by potapuff
There is a table:
doc_id(integer)-value(integer)
Approximate 100k doc_id and 27?? rows.
Majority query on this table - searching documents similar to current document:
select 10 documents with maximum of
(count common to current document value)/(count ov values in document).
Nowadays we use PostgreSQL. Table weight (with index) ~1,5 GB. Average query time ~0.5s.
Should I transfer all this to NoSQL base, if so, what?