I should add that this isn't the first time this has happened, but it is the first time since I reduced the allocation of RAM for PostgreSQL in the configuration file. I swore that that was the problem, but I guess not. It's been almost a full week without any usage spikes or service interruptions of this kind, but all of a sudden, my RAM and CPU are maxing out again at regular intervals. When this occurs, the instance is unreachable until the issue resolves itself, which seemingly takes 5-10 minutes.

The usage spikes only started today out of a seven-day graph; they are far above my idle usage.

I thought the issue was something to do with Lemmy periodically fetching some sort of remote data and slamming the database, which is why I reduced the RAM allocation for PostgreSQL to 1.5 GB instead of the full 2 GB. As you can see in the above graph, my idle resource utilization is really low. Since it's probably cut off from the image, I'll add that my disk utilization is currently 25-30%. Everything seemed to be in order for basically an entire week, but this problem showed up again.

Does anyone know what is causing this? Clearly, something is happening that is loading the server more than usual.

I just used the tool linked here in the documentation to create a Bootstrap theme, but I can't find the folder they're referencing. I've used Ansible to install Lemmy, which is working fine, but I'm not really sure how to handle themes as a result. Do I place them somewhere in my Ansible stuff, or is there that directory somewhere on the server? I found the Docker /volumes/ folder, but the directory names were random strings and not labeled like they supposedly are at the link above.

I used the Ansible playbook instructions and got my instance up and running, which is where I'm sending this from now. Still, I was not able to get the SMTP side of things working. Does this whole setup self-host SMTP on the Lemmy instance, or is it something I'll have to sort out externally? I've heard some people have had issues with Digital Ocean on certain ports, which is the VPS provider I'm hosting on, but even other ports I've tried have not worked.