this post was submitted on 13 Jun 2023
16 points (100.0% liked)
sh.itjust.works Main Community
102 readers
1 users here now
Home of the sh.itjust.works instance.
Join us on Matrix Chat
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
The lemmy_server code is not scaling well, lots of database contention.
Supposedly they are working on major performance improvements for the next release. No idea when it is scheduled to come out though.
The database stuff was solved today. The bigger job, happening as we speak and hopefully finishing in a week or two, is ripping out all the WebSocket stuff and replacing it with simple HTTP. No more crazy updating feeds and weird buggy vote numbers, on top of the performance stuff.
That’s great news! Is there a new release candidate with the DB changes?
What was it? Missing indexes? Bad query plans? Bad queries in general?
Glad to see websockets getting ripped out.
The hot_rank query was basically hitting the server like a truck. You can read more about it in this github issue, but basically calculating the hot rank in the database has been moved to rust.
EDIT: For clarity, the database issue was solved a bit ago, but today it was released as a Lemmy version which this server (sh.itjust.works) is now on.
Excellent! Time to upgrade my instance!
@Barbarian@sh.itjust.works
Upgrade complete! Thanks for the info. BTW, the new UI version no longer shows the UI version in the page footer.