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!

https://lemmy.world/post/1061471

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

157 points · 7 comments · view on lemmy.world

7 Comments

kurikai@lemmy.world · 20 pts · 3y (1 reply)

Awesome work everyone

Carnelian@lemmy.world · 15 pts · 3y

Literally night and day, super impressive

pleasemakesense@lemmy.world · 14 pts · 3y (2 replies)

Nice! Now I don't have to jump around between 3 accounts to browse xD

pleasemakesense@lemmy.world · 16 pts · 3y

Jesus Christ it's snappy

subtext@lemmy.world · 6 pts · 3y

I was a bit bummed because I had really started on lemmy.world and I didn’t want to lose my comment history, so I was holding out hope that the admins could get these problems resolved and voila, it’s magical how well it seems to be running

RoundSparrow@lemmy.ml · 10 pts · 3y

My instance server is now getting over 10 comments a minute delivered by lemmy.world, federation outbound is going much better.

TragicNotCute@lemmy.world · 10 pts · 3y

Amazing team effort.