• nutomic@lemmy.ml
    link
    fedilink
    English
    arrow-up
    5
    ·
    22 hours ago

    By far the most space is taken up by votes. You can disable votes (1.0 will have more options), or delete them directly from the database.

    • Dave@lemmy.nz
      link
      fedilink
      English
      arrow-up
      2
      ·
      22 hours ago

      Yeah I guess the issue is that votes are the thing that makes Lemmy what it is. Without them it’s just a stream of posts with no ranking. Hard to avoid needing that space.

      It’s not a huge amount of space, but if you’re on a cheap VPS then they don’t come with much space.

      • nutomic@lemmy.ml
        link
        fedilink
        English
        arrow-up
        4
        ·
        22 hours ago

        You could write a query to votes for remote posts older than 6 months, or something similar.

        • mesamunefire@piefed.social
          link
          fedilink
          English
          arrow-up
          1
          ·
          20 hours ago

          Or instead of individual votes do a dump like an rss. Like only update when I ask every 10 minutes or so. Get everything from x - y time and just give me the totals. Probably only good for smaller instances though.

          • nutomic@lemmy.ml
            link
            fedilink
            English
            arrow-up
            1
            ·
            12 hours ago

            Its not that easy because users can undo their votes, or change an upvote to downvote. Thats why we store every individual vote in the database. Also votes from defederated instances are discarded, which wouldnt work if there is only a total vote count from the community. And in general Activitypub is push-based, not pull-based.