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

Lemmy Support

4651 readers
4 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago
MODERATORS
 

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 2 comments
sorted by: hot top controversial new old
[โ€“] 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!