I think I know why Misskey chokes on up so often. It only estabilishes 10 connections to the database.
@matrix I doubt that's the reason, pleroma does the same.
@matrix adding more connections probably won't help, postgres itself still needs to actually serve the data. if waiting for queries regularly clogs up 10 connections, you probably need better queries, not more connections. but maybe it works in your case, worth trying out at least.
@lain
Yeah, better queries are obvious, but not something I'm going to fix.
I'm going to try it out, but first I gotta figure out how, because the code isn't setup for it.
@matrix btw, if this is also using postgres, you can probably to the same things you can do in pleroma to optimize the performance: https://docs-develop.pleroma.social/backend/configuration/postgresql/
