I have a process that deletes old data. This means partitions that are older then the set limit will be empty but still there.
Is there a easy query to delete all the empty partitions?
Did it with an alternative route. Got the partition number of the oldest data in the db and removed all that is older than this partition value.