this post was submitted on 24 Jun 2024
32 points (97.1% liked)
Lemmy Support
4622 readers
6 users here now
Support / questions about Lemmy.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
I think so. I have lemmy and everything needed running through a single docker container using Lemmy-Easy-Deploy.
Ah, you are using pretty different deployment then, even the used postgres image is different then the usual deployment (
pgautoupgrade/pgautoupgrade:16-alpine
instead ofpostgres:16-alpine
) this might or might not cause differences.I would try increasing POSTGRES_POOL_SIZE to 10-20, but I am guessing here, the idea being that lemmy is hammering postgres through the default 5 conns which increases CPU but that is a bit of stretch
It thankfully seems to have been fixed thanks to @[email protected]. Running
analyze verbose;
in postgres.The pgautoupgrade was added for the new version because this deployment is an all-in-one solution for running lemmy. And upgrading the databases turned out to be quite the effort until some user pointed the maintainer towards pgautoupgrade here.
I tried running lemmy before I found out about this, but this just makes it so much more convenient to run.