What table is the culprit? I have a cron job to shut lemmy down at 3:00am every morning and I run a TRUNCATE activity via the psql utility. If I didn't do that, my database size would swell to 50GB or more.
That's a good point. I've just been assuming that the media is the issue, but perhaps it's just the pure database 🤔 Does doing a truncate purge the media? If not, wouldn't I just be orphaning all these pictures, etc that have been downloaded? Also what about the fallout of your own users? I don't really want to drop the content that was created on the instance itself
Unfortunately, it a truncate does not purge the media. The media is controlled by pict-rs and it has its own database. I cannot speak to fallout of my own users because my Lemmy instance is strictly my own. I don't want to get into a situation where I am hosting accounts and have to deal with moderation and abuse. There are a lot of legalities surrounding this and I don't need the headache.
Support / questions about Lemmy.