this post was submitted on 03 Jun 2023
129 points (100.0% liked)
Chat
7526 readers
12 users here now
Relaxed section for discussion and debate that doesn't fit anywhere else. Whether it's advice, how your week is going, a link that's at the back of your mind, or something like that, it can likely go here.
Subcommunities on Beehaw:
This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.
founded 3 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Where are the bottlenecks? Frontend servers or on the db? I have a lot of experience running postgres at scale.
There's actually a bug report on the lemmy github involving some slow queries on the first page of issues
Thanks. I've asked in there for some EXPLAIN ANALYZE plans, so we can see which parts are slow and why. I also think running pgbouncer or a similar connection pooler would be a good idea. Running a production public facing service with only 5 db connections is asking for trouble.