4 ms·
SSD may help in the case when a query needs to process data from many time series over big time range. Data for a single time series can be laid down in a seria
by valyala 6y ago
SSD may help in the case when a query needs to process data from many time series over big time range. Data for a single time series can be laid down in a serial fashion. When reading data from many time series, then many disk seeks are usually needed for jumping between time series.
This may be optimized somehow for common case when the query touches related time series. Such optimizations are implemented in VictoriaMetrics [1], so it usually outperforms other time series databases on high-latency magnetic disks with low IOPS.
[1] https://victoriametrics.github.io/ https://victoriametrics.github.io/