As a data engineer, I’d be interested in hearing more about the SQL troubleshooting.
EDIT: It looks like !lemmyperformance@lemmy.ml is a good place to subscribe to for more technical info on some of these performance improvements.
Also the Lemmy GitHub of course contains more information on bugs/enhancements/etc.
Just edited my comment!