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
-
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