Only if all records age out at the same rate, otherwise you’re making Swiss cheese of your tables. And/or you’re losing history data.
If your rows do age out at the same time, then I’d be tempted to ask you why you’re storing logs in a relational database, because that’s essentially what you have at that point.
If your rows do age out at the same time, then I’d be tempted to ask you why you’re storing logs in a relational database, because that’s essentially what you have at that point.