Some of the major PostgreSQL performance issues are being identified and a fix was installed on the large server lemmy.world today that shows great results. I think once lemmy.ml installs that fix, things will improve, and overall the project is looking more at pg_stat_statements and other critical metrics.