this post was submitted on 03 Jun 2023
55 points (100.0% liked)

Chat

7487 readers
10 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 2 years ago
MODERATORS
 

Over the past 48 hours I have been glued to my screen trying to figure out how to make Beehaw more robust during this Reddit exodus.

My eyes are burning but I am thankful for so much financial support as well as the work of two sysadmins that have given us all a breath of fresh air.

One of the sysadmins was up until 2:30 am helping us out as a volunteer. I am so very grateful for persons such as this.

Thank you all for your continued support and patience.

you are viewing a single comment's thread
view the rest of the comments
[–] veroxii@lemmy.ml 5 points 1 year ago (14 children)

Where are the bottlenecks? Frontend servers or on the db? I have a lot of experience running postgres at scale.

[–] darkfoe@lemmy.serverfail.party 2 points 1 year ago (11 children)

There's actually a bug report on the lemmy github involving some slow queries on the first page of issues

[–] veroxii@lemmy.ml 1 points 1 year ago

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.

load more comments (10 replies)
load more comments (12 replies)