> And $deity help you if you want to do hourly roll-ups of all series for a short time range, as RAM usage is wildly unpredictable. I think I went properly mad

> And $deity help you if you want to do hourly roll-ups of all series for a short time range, as RAM usage is wildly unpredictable. I think I went properly mad while trying to troubleshoot this. The same query sometimes pulls 5GB, sometimes 20GB, sometimes 50GB and sometimes OOMs at 200GB memory pulled beyond base load of the system. And there's no query planner, no execution log, no metrics to help you. And most documentation or threads about it can be summarized as "well sucks to be you, eh? Maybe less data would be an option I guess" We don't do that anymore and just roll up a very small select number of metrics. And yeah, we've committed to Postgres as our main DB 2 years ago or so, and currently time is clearing up to start work with TimescaleDB. Zabbix is supposed to be great with it.