What are the recommended settings for connecting via pgbouncer >= 1.21 in pool_mode = "transaction"
?
#1195
steve-marmalade
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
There is significant discussion about using asyncpg with pgbouncer (and SQLAlchemy), e.g.
#837 and
sqlalchemy/sqlalchemy#6467
However, the majority of that discussion took place before PgBouncer 1.21 was released, which included support for prepared statements in transaction mode.
My question is, when running a new version of pgbouncer, what steps are still recommended to take? Are these suggestions still relevant?
prepared_statement_name_func
to avoid duplicate prepared statement names?server_reset_query_always
?statement_cache_size=0
?NullPool
?Thank you
Beta Was this translation helpful? Give feedback.
All reactions