4 ms·
If integration with PostgreSQL is not a requirement, I would suggest looking at QuestDB[1] for the best performing open-source timeseries database currently on
by krn 4y ago
If integration with PostgreSQL is not a requirement, I would suggest looking at QuestDB[1] for the best performing open-source timeseries database currently on the market.
[1] https://questdb.io/blog/2021/07/05/comparing-questdb-timescaledb-influxdb/ https://questdb.io/blog/2021/07/05/comparing-questdb-timesca...
- tda 4y agoAre you sure it is the best performing? The article only compares to influx and timescale, which are very far from the fastest timeseries databases out there. How does it compare to clickhouse? I found this https://questdb.io/blog/2022/05/26/query-benchmark-questdb-versus-clickhouse-timescale/ https://questdb.io/blog/2022/05/26/query-benchmark-questdb-v..., but the numbers are so far off (and clickhouse is much slower than timescale in their examples) that I kind of struggle to believe them.
- krn 4y agoClickhouse is a data warehouse, not a timeseries database. Timeseries databases are designed with different bottlenecks in the mind: https://questdb.io/blog/2020/11/26/why-timeseries-data/ https://questdb.io/blog/2020/11/26/why-timeseries-data/