Hi ,
I'm encountering the same issue on my website which was built on 8+ ( now 10.3) ,
there's no need to hurry , my 'node_revision__body' table is less than 2GigsI included steps to reproduce , these are assumed from my website's history and specs,
I didnt reproduce them myself, this note is mainly a lead to the core problem,
I may try once I've got more time or if my table size exponentially increases,Many thanks
The essential complaint here is that Core doesn't have a feature for managing revisions at scale. For an issue like this to be actionable it should be recreated as a feature request, and it would need a plan, a design and so on.
@marelpup: Open a bug report for Node Revision Delete → regarding translations. If that module gets to a certain stage of maturity it could be considered for integration into Core.