I have a table that is capturing what is, basically, time series data
Time series data usually is concerned with "recent" data, and has a subsequent drop off date. This is ideal for partitioning by timestamp - not only do your queries only need to hit a few of the total tables, but you can simply drop old tables that contain older data. Optionally saving them first to deep storage. The DROP TABLE approach is extraordinarily better than the alternative of DELETE FROM ... WHERE ...