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?
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.
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
I don’t have plenty of storage. I will have to upgrade at some point.
There’s a
DELETE /internal/variants
endpoint specified in the pictrs docs that might remove some extra data: https://crates.io/crates/pict-rsThank you!