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!
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!
Another day, another update. More troubleshooting was done today. What did we do: - Yesterday evening @phiresky@phiresky@lemmy.world [https://lemmy.world/u/phiresky] did some SQL troubleshooting with some of the lemmy.world admins. After that, phiresky submitted some PRs to github. - @cetra3@lemmy.m...
lemmy.world announcing to public that this is installed on their production server: https://lemmy.world/post/1061471
Awesome work everyone
Literally night and day, super impressive
Nice! Now I don't have to jump around between 3 accounts to browse xD
Jesus Christ it's snappy
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
Amazing team effort.
My instance server is now getting over 10 comments a minute delivered by lemmy.world, federation outbound is going much better.