Help to choose NoSQL database for project

Posted by potapuff on Stack Overflow See other posts from Stack Overflow or by potapuff
Published on 2010-03-21T07:46:16Z Indexed on 2010/03/21 9:41 UTC
Read the original article Hit count: 361

Filed under:
|
|
|

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?

© Stack Overflow or respective owner

Related posts about nosql

Related posts about key-value-store