this post was submitted on 14 Jul 2023
63 points (98.5% liked)

Lemmy Support

4634 readers
12 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago
MODERATORS
 

hello, on my server on which only Lemmy is running, I don't understand why it fills up space all the time. Every day it increases by about 1GB thus risking reaching the limit after a short time.

It is not the images' fault because there is a size limit for uploading and they are also transformed into .webp.

The docker-compose file is the one from Ansible 0.18.2 with the limits for loggin already in it (max-size 50m, max-file 4).

What could it be? Is there anything in particular that I can check?

Thanks!

28% - 40G (3 July)
29% - 42G (4 July)
30% - 43G (5 July)
31% - 44G (6 July)
36% - 51G (10 July)
37% - 52G (11 July)
37% - 53G (12 July)
39% - 55G (13 July)
39% - 56G (14 July)
you are viewing a single comment's thread
view the rest of the comments
[–] GlitchyDigiBun@lemmy.dbzer0.com 5 points 1 year ago (1 children)

Im sure it couldn't be difficult to do a rolling purge to keep the file at a fixed size?

[–] helios@social.ggbox.fr 4 points 1 year ago (1 children)

If you need the space back on the filesystem, you could rebuild the table with VACUUM FULL. Do note that the table would be unavailable during that process as it would be locked exclusively. https://www.postgresql.org/docs/current/sql-vacuum.html

[–] Wander@yiffit.net 2 points 1 year ago (1 children)

You'd need to take your site down for a while since write access is necessary to that table to avoid duplicates. But yeah, once you've done a vacuum full you could find a way to each day trim old entries.

[–] johntash@eviltoast.org 1 points 1 year ago (1 children)

Entries older than 6 months are deleted by default, but as far as I understand it might be safe to manually delete them sooner than that?

[–] SeeJayEmm@lemmy.procrastinati.org 2 points 1 year ago (1 children)

I'm purging much more aggressively than that an so far so good.

[–] johntash@eviltoast.org 2 points 1 year ago

Good to know, thanks! I have space to spare, but I'll probably make it more aggressive to save on backup size