• SubArcticTundra@lemmy.ml
    link
    fedilink
    English
    arrow-up
    0
    ·
    8 months ago

    Do you have any idea how much storage (in GB) all the posts on Lemmy have takenup to date? (Excluding media)

    • nutomic@lemmy.mlM
      link
      fedilink
      English
      arrow-up
      0
      ·
      8 months ago

      The SQL table for posts is 1.6 GB on lemmy.ml, and 5.7 GB for comments. That probably accounts for a majority of content on the Lemmyverse.

    • phiresky@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      8 months ago

      I don’t think it’s that large. Text is very small and compressible compared to images. Well it depends on if you mean the actual database storage (uncompressed, with indexes) or a compressed copy of all the posts. You can see the post number in the URL, which on lemmy.world for this post is 11169622. That means there’s around 11 million posts total in lemmy.world’s database. If you assume each of them takes 0.5kB of storage that would be only ~ 5 GB of posts.