this post was submitted on 11 Jul 2023
166 points (98.8% liked)
Lemmy
12506 readers
38 users here now
Everything about Lemmy; bugs, gripes, praises, and advocacy.
For discussion about the lemmy.ml instance, go to [email protected].
founded 4 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
It looks like the issue I was referring to has since been edited, as it's not actually relevant to clearing this database bloat:
https://github.com/LemmyNet/lemmy/issues/3103
I mean, that post is exactly about clearing database bloat. The bulk of the bloat is in the activity table (going by the comments in the thread).
Yeah, I meant the comments that have been hidden previously made it seem like clearing it would be an issue, so I hesitated to clear it. Now that those comments have been edited, it looks like it won't break anything after all.
Gotcha. Thanks for pointing me in that direction. Seems like that table's only useful for debugging federation issues. Not sure why they'd want to keep it for 6 months.
It seems like lots of design choices were made with pre-Reddit-exodus usage in mind 😅
That's for sure. Hopefully they can pivot and start thinking about how to scale better. On one hand I don't envy the developers but it's gotta be kind exciting.