Hello all! I’m reading in data to my influx db every second. I have a retention policy in place to ensure that I don’t continuously store data and run out of disk space. However, I would also like to have a longer history period at a coarser level of granularity. So what I had in mind was this: S…

IMHO this will create more problems, here is a list of my doubts/problems: Your data won’t be kept for a longer time since the RP is the same as the original You won’t be able to aggregate, insert new points and then delete the “not aggregated ones”. (I have no clue about how to do that, but opera…

Maybe the aggregator plugin will help you. You will also be able to keep or drop the “original” (not aggregated) points. But to respect your requirements: I have a retention policy in place to ensure that I don’t continuously store data and run out of disk space I would also like to have a lo…

Since I want to graph it in grafana, I’d like to have all the data in the same measurement otherwise I’d need 2 separate graphs. This is why I was looking into getting the data stored in the same measurement.

Appreciate your insights. I think that confirms that what I’ve been thinking of, just wanted to make sure I wasn’t overlooking something :slight_smile:

Can you share how you are doing this with Telegraf + Influxdb. How did you set up your RPs and CQs?

I think this guy solved our problem [image] Down sample data in same measurement and delete old data I think this presentation may help you: DOWNSAMPLING DATA I have only done with with continuous queries in InfluxDB directly. Influx has a regex syntax from Go and other …

Downsampling older data into same measurement

Store

alberto_gcs March 3, 2022, 10:19am 7

I think this guy solved our problem

Topic		Replies	Views
Downsample into same measure? InfluxQL	4	4269	March 3, 2022
Downsampling & Data Retention Store influxdb	1	1275	January 18, 2019
Downsampling existing data Systems influxdb	3	7592	June 8, 2017
Manual data retention remarks Store influxdb	1	642	November 13, 2018
Telegraf and continuous query Systems influxdb , telegraf , time-series	1	754	September 20, 2020

Downsampling older data into same measurement

Related topics