This is just to followup from my prior post on latencies increasing with increasing uptime (see here).

There was a recent update to lemmy.ml (to 0.19.4-rc.2) … and everything is so much snappier. AFAICT, there isn’t any obvious reason for this in the update itself(?) … so it’d be a good bet that there’s some memory leak or something that slows down some of the actions over time.

Also … interesting update … I didn’t pick up that there’d be some web-UI additions and they seem nice!

27 points

There were optimizations related to database triggers, these are probably responsible for the speedup.

https://github.com/LemmyNet/lemmy/pull/4696

permalink
report
reply
23 points

For the moment at least. Whatever problem we had before, it seemed to get worse over time, eventually requiring a restart. So we’ll have to wait and see.

permalink
report
reply
10 points

Well, I’ve been on this instance through a few updates now (since Jan 2023) and my impression is that it’s a pretty regular pattern (IE, certain APIs like that for replying to a post/comment or even posting have increasing latencies as uptime goes up).

permalink
report
parent
reply
1 point

Sounds exactly like the problem I fixed and mostly caused

https://github.com/LemmyNet/lemmy/pull/4696

permalink
report
parent
reply
1 point

Nice! Also nice to see some SQL wizardry get involved with lemmy!

permalink
report
parent
reply
6 points

My server seems to get slower until requiring a restart every few days, hoping this provides a fix for me too 🤞

permalink
report
parent
reply
5 points

Try switching to Postresql 16.2 or later.

permalink
report
parent
reply
3 points

What’s new in postgres?

permalink
report
parent
reply
5 points

Reddthat has 0.19.4 too, feels indeed snappier

permalink
report
reply
2 points

Interesting. It could be for the same reason I suggest for lemmy.ml though. Do you notice latencies getting longer over time?

permalink
report
parent
reply
3 points

It’s a smaller server so I guess latency issues would appear at a slower pace than lemmy.ml

permalink
report
parent
reply
2 points

makes sense … but still … you’re noticing a difference. Maybe a “boiling frog” situation?

permalink
report
parent
reply

Lemmy

!lemmy@lemmy.ml

Create post

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.

Community stats

  • 161

    Monthly active users

  • 1.1K

    Posts

  • 14K

    Comments

Community moderators