Comment by dmitry-vsl

Probably better to use partitioned table and drop old partitions.