My lemmy instance seems to be using a lot of storage, I am the only one using it and for like 10 minutes a day. it’s currently using about 122 gb, after about 3 months of usage

 ~/l/volumes> sudo du -d 1 -h  .
47G	./pictrs
75G	./postgres
0	./lemmy-ui
122G	.

seeing the usage of other ppl this seems really big? Am i doing someting wrong? edit: it is also using a lot of memory, i dont know exactly how much but it seems to be most of my system’s available ram (16 gb)

  • hitagi@ani.social
    link
    fedilink
    English
    arrow-up
    6
    ·
    1 year ago

    I don’t remember which update it was but newer versions of Lemmy use significantly less database storage.

    • poVoq@slrpnk.net
      link
      fedilink
      English
      arrow-up
      8
      ·
      edit-2
      1 year ago

      It reduced it shortly, but the activity table is still (unecessarily) caching most of the lemmyverse for 3 months AFAIK.

      Our database went from 30GB or so down to 7GB with that update, but now it is back to 30GB or so. I even did a full database vaccuum lately, but it only shaved off 2-3GB or so.

      If my understanding is correct, then the activity table probably doesn’t need to store more than a week or so, instead of the current 3 months. But this is something hard-coded in Lemmy and can’t be easily configured.