Paragraph revision tables take up a lot of space in database

Created on 9 June 2022, over 2 years ago
Updated 7 August 2024, 5 months ago

Problem/Motivation

Paragraph revision tables take up a lot of space in database. On a project, we have cases where the size of these tables exceeds 1.5G for each field of a paragraph and the database becomes larger.
Is there any way to clean these revisions according to some configurable criteria ?

Feature request
Status

Postponed: needs info

Version

1.14

Component

Code

Created by

🇲🇦Morocco babidar

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • 🇺🇸United States Greg Boggs Portland Oregon

    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?

  • 🇮🇳India lhuria94

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

  • 🇺🇸United States Greg Boggs Portland Oregon

    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.

  • Status changed to Postponed: needs info 5 months ago
  • 🇨🇭Switzerland berdir Switzerland

    Paragraph revisions are meant to be cleaned up together with the host revisions, Orphan Purger not triggered when deleting revisions Needs review might be why that's not working together with node revisions delete, a manual orphan cleanup through the batch UI should help as a workaround.

    Other than that, I don't see what else paragraphs should do, if anything still needs a certain paragraph revision it's not up to this module to delete it on its own.

  • 🇺🇸United States Greg Boggs Portland Oregon

    Thanks, I'll give the patch a try.

Production build 0.71.5 2024