I Benchmarked TimescaleDB vs ClickHouse vs MongoDB for Observability Data - The Results Surprised Me

The author benchmarked TimescaleDB, ClickHouse, and MongoDB under identical conditions for observability workloads (logs, spans, metrics) across four volume tiers. ClickHouse showed a critical ingestion bottleneck at small batch sizes due to its async insert flush interval, with TimescaleDB outperforming it by 56x at batch size 100. TimescaleDB was selected as Logtide's default storage, with ClickHouse offered only for enterprise-scale deployments.