Pgbouncer for hydra backend database #3582
Unanswered
NireshKumarRaj
asked this question in
Q&A
Replies: 1 comment
-
Hello @NireshKumarRaj Can you elaborate a bit on the use case? Why do you want to optimize this? See also this blogpost: https://www.ory.sh/oauth2-oidc-server-performance-tuning-scale/. These improvements are merged on master, will be included in the next release, and are available already in Ory Network for production use. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi folks. I have been trying out an use case on optimizing hydra postgres db backend connection management. I was suggested by postgres community to use pgbouncer connection pooler. And in pgbouncer, transaction mode offers better improvement. We tried session mode but didn't see any improvements.
But ory hydra codebase uses named prepared statements which is not supported in pgbouncer transaction mode.
Can someone please help me with an alternative solutions for this case?
Beta Was this translation helpful? Give feedback.
All reactions