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?
You must log in or register to comment.
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.
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!