this post was submitted on 14 Jul 2023
49 points (98.0% liked)
Lemmy Support
4654 readers
21 users here now
Support / questions about Lemmy.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
You'd need to take your site down for a while since write access is necessary to that table to avoid duplicates. But yeah, once you've done a vacuum full you could find a way to each day trim old entries.
Entries older than 6 months are deleted by default, but as far as I understand it might be safe to manually delete them sooner than that?
I'm purging much more aggressively than that an so far so good.
Good to know, thanks! I have space to spare, but I'll probably make it more aggressive to save on backup size