Whether Row-wise and columnar attribute storages are persistent

General Discussions - English
1

  1. I don’t understand. Does Row-wise store all the data in memory?

  2. If logs are used to store a large amount of data, how can I save the logs for one week?

  3. How to solve the problem of insufficient storage on a single server?

Whether Row-wise and columnar attribute storages are persistent

2
  1. I don’t understand. Does Row-wise store all the data in memory?

No. The data is stored on disk. It requires attributes to be in RAM though for optimal performance. For that it prereads attributes on start.

  1. If logs are used to store a large amount of data, how can I save the logs for one week?

Just save them. What’s the problem?

  1. How to solve the problem of insufficient storage on a single server?
  • Vertical scaling: increase the storage size.
  • Horizontal scaling: add another node, split your data into multiple pieces and put it to multiple places. Then use a distributed table to combine the shards back for search. Auto sharding is in progress, but is not yet implemented.

Whether Row-wise and columnar attribute storages are persistent

Yes, they are.

3

it requires attributes to be in RAM
Will there be sufficient RAM available