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<p>[1] <a href="https://lemmy.world/post/2923697" rel="nofollow noreferrer">https://lemmy.world/post/2923697</a>