How to store statistics correctly?

Question

MongoDB

Hey!
We collect daily statistics and store it in mongoDB so that clients can then view the graphs.
The number of documents is growing, now it is already more than 28.4 million , and from 2 million documents are added daily (already almost 2.5 million).
Where is it generally correct to add such data in order to easily engage in aggregation?

Answer 1

clickhouse ?

Answer 2

Any column DB. clickhouse / influxdb is what we use.

Answer 3

Not in document-oriented databases.
Ordinary relational, columnar.

Answer 4

Here the main question is, do you want to store statistics or events?