The federated Reddit alternative Lemmy is being attacked[1] by bots abusing the lack of Postgres query optimization in what is still the early days of the platf

The federated Reddit alternative Lemmy is being attacked[1] by bots abusing the lack of Postgres query optimization in what is still the early days of the platform. Any assistance with query analysis and optimization would be most appreciated <3 [1] https://lemmy.world/post/2923697 https://lemmy.world/post/2923697