3 ms·
Haha very cool use! Yeah reading up on TimescaleDB vs. Clickhouse it seems like columnar storage and Clickhouse will be faster and better compress the time seri
by PolarizedPoutin 3y ago
Haha very cool use! Yeah reading up on TimescaleDB vs. Clickhouse it seems like columnar storage and Clickhouse will be faster and better compress the time series data. For now I'm sticking to TimescaleDB to learn Postgres and PostGIS, but might make a TimescaleDB vs. Clickhouse comparison when I switch!
- rkwasny 3y agoI can replicate your benchmark when I get a moment, the data, is it free to share if I wanted to make an open browser? I have a feeling general public has very limited access to weather data, and graphs in news that state "are we getting hotter on colder" are all sensational and hard to verify.
- cevian 3y agoPlease note that TimescaleDB also uses columnar storage for its compressed data. Disclosure: I am a TimescaleDB engineer.