slowly but surely I will come to a point where I run out of disk space for the Influxdb running on the server.
I never created additional retention policies besides the default autogen.
Can you tell me what RPs you set up? Any recommendations?
I am using 30d> 15min, 365d> 60min for beside of autogen.
Maybe others have other values.
thanks for your reply.
So I guess you created two CQs as described here https://docs.influxdata.com/influxdb/v1.7/guides/downsampling_and_retention/
to do the automatic downsample?
As I understand it, I will also have to change the queries in the Influxconnector inside OpenEMS to be able to query data outside of autogen.
That whole retention policy thing is a bit confusing to me. It seems that just creating additional RPs wouldn’t change anything unless creating CQs and therefore also changing the queries inside OpenEMS to be able to retrieve downsampled data.
there are two related approaches.
All in all I am currently not too happy with InfluxDB because of these issues. I hope that InfluxDB version 2 will solve them. I am also looking into TimescaleDB (https://www.timescale.com/) which seems to handle these cases much smarter, has built-in replication on server clusters and builds on rock-solid PostgresQL - but I did not start any development in that direction yet.
thank you for the explenation. Now I have a much clearer understanding.