You can easily drop the oldest month every 1st using a delete statement.

Queries can be fast with indexes without adding complexity.