Please, major Lemmy instances...
Install the pg_stat_statements extension and share with us what your queries are looking like on Beehaw, Lemmy.world, Lemmy.ml so that we can start to identify the performance problems in the design and code.
Anything about running your own Lemmy instance. Including how to install it, maintain and customise it.
Be sure to check out the docs: https://join-lemmy.org/docs/en/administration/administration.html
If you have any problems, describe them here and we will try to help you fixing them.
Install the pg_stat_statements extension and share with us what your queries are looking like on Beehaw, Lemmy.world, Lemmy.ml so that we can start to identify the performance problems in the design and code.