I’m hosting my own Lemmy instance and the disk usage is getting high. Since I don’t really care about old content (say older than a month), is there any way to purge any posts, comments, etc older than that? Even if it’s not built into Lemmy an SQL query would work too.
You can prune the activity table, but have a read of this PR: https://github.com/LemmyNet/lemmy/pull/3583
This may fix much of the DB bloat
Yeah that saved about 7gb, thanks!