this post was submitted on 24 Jun 2024
32 points (97.1% liked)
Lemmy Support
4650 readers
1 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
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.