this post was submitted on 12 Mar 2024
32 points (100.0% liked)

Reddthat Announcements

694 readers
1 users here now

Main Announcements related to Reddthat.

founded 1 year ago
MODERATORS
ticoombs@reddthat.com
reddthat@reddthat.com
example@reddthat.com
32
Maintenance from Postgres 15 to Postgres 16 - at 00:30 UTC AND an explanation of what is happening with Lemmy.World and Reddthat, and why it affects only Reddthat! (reddthat.com)
submitted 8 months ago* (last edited 8 months ago) by ticoombs@reddthat.com to c/reddthat@reddthat.com
21 comments fedilink hide all child comments
 

Edited: this post to be the Lemmy.World federation issue post.

We are now ready to upgrade to postgres 16. When this post is 30 mins old the maintenace will start

you are viewing a single comment's thread
view the rest of the comments
[–] ticoombs@reddthat.com 4 points 8 months ago (1 children)

Yes. Unfortunately the information gleamed boils down to two reasons:

  • their db was slow to respond
  • their db server ended up being 25ms away from their backend servers which caused the slowness.

Our db server is occasionally slow to respond, but most requests from LW complete in less than 0.1 second. Unfortunately there are times when they take longer. These longer ones are going to be the problem (I believe). As all activities are sequential servers can only catch up as fast as they can process them.

What i've found in the past 30 seconds is that it is not necessarily out database that is the problem but possibly the way lemmy handles the federation. I'm chatting with some of the admins on reddthat and making pretty graphs while looking at walls of logs.

[–] Blaze@reddthat.com 2 points 8 months ago (1 children)

I see, thank you for your work!