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
 

Anyone know why? Any way we can promote sh.itjust.works to lighten their load possibly?

you are viewing a single comment's thread
view the rest of the comments
[–] slashzero@hakbox.social 8 points 1 year ago* (last edited 1 year ago) (1 children)

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.

[–] Barbarian@sh.itjust.works 11 points 1 year ago* (last edited 1 year ago) (1 children)

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.

[–] slashzero@hakbox.social 4 points 1 year ago* (last edited 1 year ago)

Excellent! Time to upgrade my instance!

@Barbarian@sh.itjust.works

  • BE 0.17.4
  • UI 0.17.4

Upgrade complete! Thanks for the info. BTW, the new UI version no longer shows the UI version in the page footer.