Hello,
I use the victron docker Images to push all Data from MQTT to a local Influx DB.
This is a very nice solution, having detailed 6 samples per Second for all measurements.
The Data consume about 300 MB per Day what is fine for a few month.
But I want to use this also for long term storage of the Data (>10 Years) as well.
So I want to use the influx data aggregation and retention methods to down sample old data.
Data older as 1 Month should get aggregated to 10 minutes slots, reducing the data consumption from 9 GB / Month to about 15 MB/Month.
Anyone already done this and can provide his downsampling task script? Would be great to share this, that not everyone needs to write it again and again.
Thank you
