|
|
|
|
|
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) |
|