ClickHouse压缩和压缩算法有关,也和表结构相关;
CH压缩算法:
CH支持LZ4和ZSTD 两种压缩算法, LZ4在速度上会更快,但是压缩率较低,ZSTD正好相反。尽管ZSTD比LZ4慢,但是相比传统的压缩方式Zlib,无论是在压缩效率还是速度上,都可以作为Zlib的替代品。
详情参考: https://www.percona.com/blog/2016/04/13/evaluating-database-compression-methods-update/
查看本机压缩算法:
metrika.xml 文件的<method></method> 标签, 默认lz4;
查看压缩率:
select
sum(rows) as "总行数",
formatReadableSize(sum(data_uncompressed_bytes)) as "原始大小",
formatReadableSize(sum(data_compressed_bytes)) as "压缩大小",
round(sum(data_compressed_bytes) / sum(data_uncompressed_bytes) * 100, 0) "压缩率"
from system.parts;