The docker-compose.yml file in the docker folder has a config for postgres logging. We use it to diagnose performance issues in prod. There’s a DB tag on the lemmy issue tracker, I suggest using that to track performance issues.
This is all 100% correct. People have already written captcha-bypassing bots for lemmy, we know from experience.
The only way to stop bots, is the way that has worked for forums for years: registration applications. At lemmy.ml we historically have blocked any server that doesn’t have them turned on, because of the likelihood of bot infiltration from them.
Registration applications have 100% stopped bots here.
Lemmy v0.18.0 Release (join-lemmy.org)
Lemmy Benchmarking - Working on tooling
Heyho,...
Protect. Moderate. Purge. Your. Sever.
Please. Captcha by default. Email domain filters. Auto-block federation from servers that don't respect. By default. Urgent....