Re: range columns including datetime column

[Rob Voyer]

That is a good suggestion, but period is (5-hourly, 4-daily, 3-weekly, 2-monthly, 1-yearly). So I keep the 1-3 data forever, but the 4,5 data I kill after 3 months as it is the majority of the data. So I really only need the rotating partitions for the 4,5 periods, hence the structure I came up with.

I think it would make sense for my initial idea to work, essentially a bubbling up as high as it can go in the rules. Or perhaps allowing a reuse of a partition in more than one spot in the partition rules. That might be tricky though but possibly more flexible. Thanks for your help.