Paragraph revision tables take up a lot of space in database

This is a major issue. So far, none of the revision delete modules I have tested have support for Paragraphs revisions. Has anyone found a solve for this?

We are also facing this issue and its a pain, however we plan to do custom revision purge solution.

that would be awesome. You should contribute the work.

Node revision delete module is a popular solution and has the UI for setting rules to delete revisions of nodes which is a good starting place for this feature.