3 ms·
My guess is that at 5min resolution (288 data points per day), you're probably just better off going stock SQL. My understanding is that time series DBs start g
by matt2000 7y ago
My guess is that at 5min resolution (288 data points per day), you're probably just better off going stock SQL. My understanding is that time series DBs start getting useful at higher write loads that standard SQL DBs aren't necessarily optimized for, and where you might want things like data to coalesce into larger timeframes to save storage, etc. I'm not an expert though, just what I've seen from my somewhat limited experience.
- akulkarni 7y ago(TimescaleDB founder) One of the advantages of TimescaleDB is the additional SQL functions that make time-series manipulation easier (eg interpolation, locf, aggregating by arbitrary time intervals). So if you need any of that functionality I'd recommend taking a look, even if you don't have massive scale.