Currently I have 3 years of storage of process measurements every 1 second, today I find myself with a 50Gb DB. I have created a CQ to downsampling in real time every 5sec and store it in another metric, but I find myself in the need to manually downsampling of the data already stored. I understand that it must be something normal but I have not found information about it. Could you help me?
Thanks and sorry for my English