What version are you using? How long are you keeping data for? It is
possible to partition by hour or would that exceed the number of
recommended partitions too quickly for your retention time period? Else, I
would partition on date according to the timezone of your data. Selecting
from multiple partitions for the aggregate should be performant enough in
most cases. The truncate / detach type commands may need to be the priority.