I have my own Lemmy instance (Lemmy.emphisia.nl) but I had to take it offline, after running a while it was using more than half of the system memory (16gb in total). Causing the computer to crash as there are a lot of other services also running on it.
The problem appears to come from postgress. In btop I can see it spawning a lot of processes all taking up about 80 MB in the beginning but rising as it runs, rising as high as 250 MB per process.
I have already tried adjusting the postgress config to be optimized for less memory, but it seems to do nothing.
Is this normal, and if not, what is going wrong?
It has zswap and a swapfile of about 8 gb, and it gets fully utilized