Nice post. I have the following situation :

My table contains 2 years of history and 5 billions of records.

I took the option to create partition per week. Each week is...