Company
Date Published
Author
Dale McDiarmid
Word count
5014
Language
English
Hacker News points
None

Summary

In this post, we'll demonstrate the value of investing time in your ClickHouse schema through strict types and codecs to minimize storage and improve query performance. We've reduced our uncompressed size from 135GB to around 36GB through type optimizations and reduced our compressed size from 4GB to 1.42GB with codecs, providing significant gains on storage and potentially accelerating queries.