This isn’t a new problem - here’s another post that’s much the same: High memory usage problem - #4 by coofercat
In that post, it suggests using the latest versions which can put some indexing information to disk rather than in ram (assuming you have SSD disks, this might work quite well). I haven’t yet tried that, although it’s ‘in the plan’.
The other suggestion is to downsample data fairly aggressively. This means less points have to be held in ram, so saves you memory. It seems reasonable enough, although I’m not sure how it would cope with years of old data (even if downsampled). I had a look at this, but couldn’t really make it work without using Kapacitor (which I haven’t got to installing yet).
