I have a Time Series Database with over 2.500 Million registers
The structure is the following.
I would like to have some advice to improve efficiency.
I wonder If it would be a good idea to partition the data by month or by year ? All queries are monthly or yearly based.
Any idea is welcome.