Recommendations on instance maintenance?

My database is already getting to the size of almost 1GB so it made me think about some questions I have regarding maintenance of my Lemmy instance:

What cleanup is recommended on the database?
What is the default length of time that pictrs holds onto its cached data and how to clear the cache?
Any other recommendations you can think of?

9 comments

You can store media in object storage (S3) to save a lot of money, although I haven’t made the transition yet. https://lemmy.eus/comment/165512
- I am currently self-hosting my Lemmy instance out of my home and reverse-proxied over a WireGuard tunnel. I suppose I am not in immediate danger. Is it possible to use S3 storage with my current setup?
  
  Yes I don’t see any reason why not, but if you are hosting at home you likely have plenty of storage yourself and might not want to mess with configuring S3
The activity table is by far the largest. There's an open issue to reduce the cleanup time on it. I can find it later.
- Thank you! I would appreciate the help very much. Please take your time though.
  
  https://github.com/LemmyNet/lemmy/issues/3103
There's a DELETE /internal/variants endpoint specified in the pictrs docs that might remove some extra data: https://crates.io/crates/pict-rs
- Thank you!

9 comments