Big Lemmy server lemmy.world has put into production critical performance fixes from a runaway SQL query identified by analyzing pg_stat_statements output - and greatly reduced their server overload!

lemmy.world

Big Lemmy server lemmy.world has put into production critical performance fixes from a runaway SQL query identified by analyzing pg_stat_statements output - and greatly reduced their server overload!

lemmy.world

RoundSparrow@lemmy.mlM to

Lemmy Server Performance@lemmy.ml · 1 year ago

lemmy.world announcing to public that this is installed on their production server: https://lemmy.world/post/1061471

You must log in or register to comment.

Chat

Lemmy Server Performance@lemmy.ml

lemmyperformance@lemmy.ml

Create a post

You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !lemmyperformance@lemmy.ml

Lemmy Server Performance

lemmy_server uses the Diesel ORM that automatically generates SQL statements. There are serious performance problems in June and July 2023 preventing Lemmy from scaling. Topics include caching, PostgreSQL extensions for troubleshooting, Client/Server Code/SQL Data/server operator apps/sever operator API (performance and storage monitoring), etc.

Visibility: Public

This community can be federated to other instances and be posted/commented in by their users.

1 user / day
1 user / week
1 user / month
1 user / 6 months
0 local subscribers
0 subscribers
42 Posts
34 Comments
Modlog