this post was submitted on 07 Nov 2023
6 points (87.5% liked)
Lemmy Support
4652 readers
1 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
The last time I checked postgres gets big becouse of a log activity table used for deduplication, it stores the data of 6 months. The devs mentioned you could be deleting it up to some point (IIRC they said 3 months, but confirm first).
As for pictrs, lemmy caches a lot of stuff, so it copies a lot of data from other instances even when it's advertised only media from your instance is stored in your server.
My solution was to disable pictrs since I don't upload media.
Other solutions I've heard about are to ask users of your instance to upload media to any other media hosting service, the images uploaded to lemmy are just seen as urls, so it wouldn't be any different.