What is ClickHouse how it compares to PostgreSQL and TimescaleDB for time series

1

Logtail

Disclaimer: I'm a co-founder of https://logtail.com, ClickHouse-based hosted log management platform. PostgreSQL, TimescaleDB, and ClickHouse are all impressive pieces of software. We use both PostgreSQL and ClickHouse at Logtail. ClickHouse shines for true OLAP use-cases and is <i>very</i> hard to beat performance-wise when configured properly. Example: > Poor inserts and much higher disk usage (e.g., 2.7x higher disk usage than TimescaleDB) at small batch sizes (e.g., 100-300 rows/batch). If your consistency requirements allow, you could use the Buffer Table Engine to get blazing fast inserts:.

#Log Management #Log Analyzer #Logging 10 social mentions

2

VictoriaMetrics

I think it is worth noting while Clickhouse is often used for time series store it is not particularly designed for this use case, but more for storing logs, events and similar data. VictoriaMetrics would be interesting comparable which is inspired by Clickhouse design but Optimized for time series store in particular https://victoriametrics.com/.

#Monitoring Tools #Time Series Database #Databases 17 social mentions

3

Fred & Farid

Most useful economic or financial markets data is some kind of time series. For example, what was the maximum price of a stock in the last year, and how does it compare to the current price? FRED (https://fred.stlouisfed.org/) is a great resource for publicly available economic time series data.

#Development #Marketing Platform #Project Management 130 social mentions