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!
Try switching to Postresql 16.2 or later.
What’s new in postgres?
Nothing particular, but there was a strange bug in previous versions that in combination with Lemmy caused a small memory leak.
In my case it’s lemmy itself that needs to be restarted, not the database server, is this the same bug you’re referring to?
Yes, restarting Lemmy somehow resets the memory use of the database as well.