M
M
Multigame2017-03-14 16:13:43
NoSQL
Multigame, 2017-03-14 16:13:43

What DBMS is better to choose for texts?

Good afternoon.
There was a task - to store texts of various lengths (100 - 5000 characters). The business process only needs text. Sampling only by exact key equality. For sharding, they also thought to add the "date" field (data a month ago will be requested hundreds of times less often. Number of records up to 3kkk.
Priorities. Less disk consumption, RAM. Reading speed is in second place. Write is in third place. Well, from the vital it is clear that this whole thing needs to be sharded (I can’t imagine 30k GB on one machine) and at least minimally replicated. Previously, mongodb was
used for such tasks. However, functionally, in principle, key-value is enough ... In general, I will listen to any options .

Answer the question

In order to leave comments, you need to log in

2 answer(s)
E
Eugene, 2017-03-14
@Nc_Soft

elasticsearch

M
Multigame, 2017-03-16
@Multigame

In general, a day of reading conflicting IMHO on the Internet led me to the idea that postgresql looks pretty good as a text storage ...
Mainly based on - https://habrahabr.ru/post/272735/

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question