Algorithms and Data Structures Matter

Number of IoT devices: 90k

Volume: 24h of measures

 

DB engines:

PostgreSQL:  1346,89 GB

InfluxDB: 92,16 GB

VictoriaMetrics: 19 GB

Clickhouse: 2.75 GB

Query of last measures for all devices:

VictoriaMetrics: 20-40s

Clickhouse: 1.5-2s