this post was submitted on 24 Jun 2024
33 points (97.1% liked)
Lemmy Support
4622 readers
19 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
According to this https://stackoverflow.com/a/72966651/5881796
The extension is not loaded:
CREATE EXTENSION pg_stat_statements;
I added pg_stat_statements, and ran it. This was the result:
do you also have pict-rs connected to this postgres instance? that is surprisingly low number to me, I would have expected anywhere between 20-50 active connections (I use 50 for lemmy and 20 for pict-rs, configured in their respective conf files)
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.