Lemmy Support

4655 readers

9 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago

MODERATORS

dessalines@lemmy.ml

Is there any way to purge old content? (lemmy.pipe01.net)

submitted 1 year ago by pipe01@lemmy.pipe01.net to c/lemmy_support@lemmy.ml

2 comments fedilink hide all child comments

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 are viewing a single comment's thread
view the rest of the comments

[–] BlueEther@no.lastname.nz 4 points 1 year ago (1 children)

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

[–] pipe01@lemmy.pipe01.net 1 points 1 year ago

Yeah that saved about 7gb, thanks!