If any of you are experiencing the same issue, it makes sense to automatically perform a deep copy once in a while on incrementally updated tables. We have this scheduled weekly and the job is quite fast (runs in 6min). We were able to reduce the disk usage by 25% after not performing this for over a month.
If your in interested in the procedure please drop me a line firstname.lastname@example.org.
Please sign in to leave a comment.