#Clickhouse
It's pretty awesome when it comes to how columnar database works since it's possible to apply compression depending on your column type. Imagine having the same data with the normal RDBMS. How much would that cost us in terms of the storage?
Just look at one of the columns: from 550 GB to 602 MB. Compression ratio is at 946x! 🤯
But please don't use Clickhouse for everything. They have their own usage and limit, which is pretty much the same for everything. For an example, deleting data is not something they preferred. Heck, they even have their own name which is "lightweight delete".
You can even customize the compression. You can choose between: LZ4, ZSTD, LZ4HC and many more.
References: clickhouse.com/blog/optimize…
#sharing
Mar 16, 2024 · 11:45 PM UTC



