3 ms·
> Compression and aggregation performance in TimescaleDB is much worse than ClickHouse You are likely basing this off on an old version of TimescaleDB. For th
by akulkarni 6y ago
> Compression and aggregation performance in TimescaleDB is much worse than ClickHouse
You are likely basing this off on an old version of TimescaleDB.
For the last year TimescaleDB has included native compression (in part by storing data in a columnar format):
https://blog.timescale.com/blog/building-columnar-compression-in-a-row-oriented-database/ https://blog.timescale.com/blog/building-columnar-compressio...
TimescaleDB now implements delta-delta, Gorilla, and other best-in-class compression algorithms:
https://blog.timescale.com/blog/time-series-compression-algorithms-explained/ https://blog.timescale.com/blog/time-series-compression-algo...
This has yielded 94%+ compression, which should make TimescaleDB and Clickhouse fairly similar in storage compression.