this post was submitted on 16 Jul 2023
17 points (100.0% liked)

Lemmy Support

4633 readers
1 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago
MODERATORS
dessalines@lemmy.ml
17
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
1 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.

top 1 comments
sorted by: hot top controversial new old
[–] BlueEther@no.lastname.nz 1 points 1 year ago

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