this post was submitted on 07 Nov 2023
6 points (87.5% liked)

Lemmy Support

4661 readers
43 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago
MODERATORS
 

Hello, I have 160GB to run Lemmy but I saw that as much as 77GB is used by pictrs.

Is there any way to clear the image cache or delete any pictures that are too heavy?

Also 37GB for postgres seems like a lot to me, is there any cache or temporary file that can be cleared?

edit: I am using Lemmy 0.18.5

all 10 comments
sorted by: hot top controversial new old
[–] txmyx@feddit.de 3 points 1 year ago* (last edited 1 year ago) (1 children)
  1. Upgrade your storage. 160GB is nothing and 1TB SSDs are cheap
  2. You could delete pictures, but then the posts are broken
  3. You could archive old pictures. The pictures will have a longer load-time. Also I don't think archiving pictures is a feature of lemmy, so you would have to implement it yourself

Edit: I think postgres is so big, because of backups. You could delete those, but that's risky

[–] skariko@feddit.it 2 points 1 year ago (1 children)

Thank you for your answer!

Since I currently use Hetzner the only way to get more space is to upgrade the server (at a not inconsiderable cost).

The alternative might be to purchase SSD block storage volumes which are definitely lower priced (5€ per month for 100GB) however it would be interesting to know if there is a guide for Lemmy for this or if others have had positive experience doing this.

[–] nachtigall@feddit.de 8 points 1 year ago (1 children)

You could get a storage box which is just 3.81€ for 1TB and mount it via NFS or SSHFS. That’s how we are doing it at Feddit.de

[–] skariko@feddit.it 3 points 1 year ago (1 children)

Thanks i think this is a great idea.

Since this problem I think is quite common (at least from reading a few threads and comments around) it might be interesting to create a guide especially regarding the part of having lemmy use this/mounted volume instead of the default one.

I in the meantime will try to look around for some information on how this can be done, any advice is definitely welcome.

Thanks!

[–] nachtigall@feddit.de 3 points 1 year ago* (last edited 1 year ago) (1 children)

I'd just ping @wintermute@feddit.de here as he might tell you more about it.

[–] Theoldwarrior@lemmy.world 0 points 1 year ago* (last edited 1 year ago) (1 children)
[–] wintermute@feddit.de 3 points 1 year ago* (last edited 1 year ago)

Best option would be to ask for support in the Matrix admin-channel,
also, if you have any specific questions, pls contact me on Matrix.

[–] pe1uca@lemmy.pe1uca.dev 3 points 1 year ago

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.

[–] willya@lemmyf.uk 2 points 1 year ago