17

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?
top 9 comments
sorted by: hot top controversial new old
[-] OutrageousUmpire@lemmy.world 6 points 1 year ago* (last edited 1 year ago)

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?

[-] OutrageousUmpire@lemmy.world 5 points 1 year ago

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.

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.

[-] Nugget@lemm.ee 4 points 1 year ago

There's a DELETE /internal/variants endpoint specified in the pictrs docs that might remove some extra data: https://crates.io/crates/pict-rs

load more comments
view more: next ›
this post was submitted on 13 Jul 2023
17 points (100.0% liked)

Lemmy Support

4650 readers
1 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago
MODERATORS