We have a 9xx G table which we need to trim down in size. When we started the delete on DB table, the process continued for full day causing strain to our whole system.
To delete rows and considerable GB of data, we wanted to evaluate following things
- Is there a way i can choose 50G of data to delete and commit it?
- Is there a way i can know size of each row?
- Is there a way i can choose chunks of data to delete/commit without overwhleming the whole set of nodes?
Any answers appreciated