14 days later, my postgres directory was 12GB. I was still on 18.1. Updated to 18.3 just now. Postgres directory was downscaled to 2.6GB !!! Thank you Lemmy dev’s and contributors !!

pictrs isn’t even taking up that much space, postgres takes up most !

# du -sch volumes/*
8.0K	volumes/lemmy-ui
3.4G	volumes/pictrs
8.2G	volumes/postgres
12G	total

I also noticed the logs were growing and taking up quite some gb’s. I’ve used truncate to make the syslog smaller and journalctl vacuum to keep that smaller

i’m trying to find documentation for this config but can’t find any. Do you have a link maybe ?

thanks for your detailed how-to ! Will try this, hopefully it holds 2 more weeks I’m leaving for holidays now :)

oh it’s visible because I’m admin/ mod ?

actually I did delete the server (after creating a snapshot of it) a week or so ago. But this morning I wanted to check lemmyfly.org, couldn’t load the page. Checking my Hetzner dashboard I noticed CPU was spiked at 200%?! It did drop again though, but apparently had last for 2-3 minutes. But prometheus was down, so no graphs apart from the hetzner ones. I doesn’t relate to network traffic spikes, so I don’t know what caused it. I’ve started the prometheus server again (that snapshot was really useful :) ) and will leave it on for a couple of months now.

current system consumption:

I might need to get an extra volume for storage, Lemmy is starting to eat up the root filesystem… Does anyone know how I re-configure Lemmy to look at a different volume for storage ?

http_response metrics are also up, using https://github.com/martin-helmich/prometheus-nginxlog-exporter

would be nice to see the numbers go up :)

Let us know your findings when you did!

i’m now looking into logging more specific http request data. Maybe https://github.com/martin-helmich/prometheus-nginxlog-exporter?

I use namecheap’s email service privateemail since a couple of years. Google workspace was great, but don’t need the other features anymore and this is fifth of the price https://www.namecheap.com/hosting/email/