Could be what communities you are subscribed to. I run a small instance with about 3ish users, and here are my stats after about 3 months as well:
9.5G ./pictrs
12G ./postgres
8.0K ./lemmy-ui
What version of lemmy are you using? A recent update also introduced some space savings in the database (I think).
how do i check what version i am using?
If viewing in a web browser, scroll to the bottom of the page. It'll say something like "BE: 0.18.5".
Edit: If you are hosting it yourself in docker, don't use the :latest tag. As of right now that will install 0.19 which is still in alpha. Use dessalines/lemmy:0.18.5
You used one of these subscribe to all community scripts, no? Otherwise it is hard to reach these figures as a single user instance.
However for the memory, I also have a hard time understanding why it eats up all ram. I am currently restarting the Lemmy backend twice a day to prevent the database from using all the memory and the system subsequently running out of memory. It definitely looks like some sort of memory leak, but not all instances seem effected. I already tried a few things to fine-tune the database and pool size etc. but it doesn't seem to help.
oh I used like a tool to speed up federation, maybe that caused it? it was called maybe that caused it?
yes, mostly. This tool basically instructs your lemmy instance to try and fetch the entire Lemmyverse and mirror it on your server.
I don't remember which update it was but newer versions of Lemmy use significantly less database storage.
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.
It’s all the images being cached from other servers. If you haven’t uploaded any images to your instance, you can just delete the content of the pictrs folder.
This will also delete all the user and community avatars though, as sadly Lemmy does not distinguish these from other images.
Wasn’t it a single user instance?
And if i did upload images on my instance haha
Then you would also have to delete those images. Unfortunately, there's no easy way to delete the cache of images that pictrs stores :(
A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.
Rules:
Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
No spam posting.
Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
No trolling.
Resources:
Any issues on the community? Report it using the report flag.
Questions? DM the mods!