That was more or less the default of the PostgreSQL container and it ran like ass because I don't have a SSD.
Basically I had to give MySQL a ton of RAM for Nextcloud and PostgreSQL for Lemmy. For now I've put both on the same PostgreSQL instance and let them battle out who gets the assigned RAM by themselves.