"Jochen" == Jochen Bern via dovecot <dovecot@dovecot.org> writes:
On 13.02.25 13:55, Anatoliy Zhestov wrote: [...]
5 increase the pool in postgres [...] However, the performance of the auth service seems limited by one core and cannot rise above 30-40 logins per second for our processor (60-70 with warm cache). Still, is there any way to parallelize this?
What exactly *is* saturating that single core? My guess would be that it's actually a PostgreSQL process ... ?
And if you just do connections to your postgres server, how many lookups can you do directly?
Do you have any indexes on your tables as well? Can you connect and do:
select * from USERS_TABLE;and see what you have, then do an:
explain select id from USERS_TABLE WHERE username =
'bob@example.com'; or whatever your query as done by dovecot is, and see what it says on speeding things up. Even with 60,000 rows of users, that query should be so quick it's not funny.
https://dba.stackexchange.com/questions/331757/postgres-using-a-single-proce... https://stackoverflow.com/questions/71416125/postgresql-uses-only-one-core
Kind regards,
Jochen Bern Systemingenieur
Binect GmbH_______________________________________________ dovecot mailing list -- dovecot@dovecot.org To unsubscribe send an email to dovecot-leave@dovecot.org