Delta - Stores the difference between consecutive values instead of the values themselves. Best suited for monotonically increasing sequences.
DoubleDelta - Calculates the difference between differences (second derivative). Provides excellent compression for time series data with consistent intervals, such as timestamps or metrics with steady growth rates.
Gorilla - Optimized for slowly changing floating-point values. Ideal for data like stock prices, temperature readings, or sensor measurements where values change gradually over time.
T64 - Developed by Yandex, this codec achieves compression effects similar to Gorilla but uses a different approach. Works well with integer types by trimming unused high bits.
FPC - a codec for floating point compression (it worse than Gorilla and pure ZSTD) it works well on some data.
GCD - Greatest Common Denominator
Don't apply some codecs from random recommendation.
estimateCompressionRatio function()
https://www.youtube.com/live/iCKEzp0_Z2Q?si=HtVBAhdEiXgh6zqP&t=204
block sizes ?
ZSTD for select queries it will be beneficial to use a higher level of compression. But insertion will be slower.
https://www.youtube.com/watch?v=7wbfKTlieOo - specify default compression codec
select * from system.codecs
https://www.youtube.com/live/_9IBOM3pR4U?si=CwUVCf10qZBlvfT_&t=153