What are the main benefits of columnar storage?

Columnar storage is especially beneficial for workloads that analyze large amounts of data. Because the data is stored together, databases can often be compressed efficiently and the data in the fields that are accessed in a query can be read. That makes it easily usable for dashboard, reporting, business intelligence and analytics processing. But it may not work well for applications which frequently add or modify the records one by one. When evaluating storage strategies, it's important to recognize that the specific type of strategy to use depends on the type of workload, the size of the data, how the data is accessed and the performance expectations. Datalance can be useful in helping to assess storage strategies.

View more: https://datalance.net/blog/columnar-database/