Choosing ClickHouse codecs per column profile
A 100-billion-row table at 4.37 bytes per row. The codec behind each column, the number it produced, and the loop to repeat the test on your own data.
measured ▸ 269.6x on the sort-key timestamp · 4.37 bytes per row over 100.78 billion rows
clickhouseclickhouse codecscompression ratiosort keybytes per rowdoubledeltat64disk budget