Hacker News new | ask | show | jobs
by mfreed 1365 days ago
TimescaleDB supports compression for all data types, it just uses type-aware compression algorithms that it applies automatically/transparently based on typing.

- Gorilla compression for floats

- Delta-of-delta + Simple-8b with run-length encoding compression for timestamps and other integer-like types

- Whole-row dictionary compression for columns with a few repeating values (+ LZ compression on top)

- LZ-based array compression for all other types

https://www.timescale.com/blog/building-columnar-compression...

So as to your question, just turn on compression; it's very common to see 94-97% reduction in storage.

(Timescale co-founder)