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)

  • poVoq@slrpnk.net
    link
    fedilink
    English
    arrow-up
    7
    ·
    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.