Expose PgBouncer max_prepared_statements in the Advanced Configuration
As Database Administrator or Engineer,
I want to be able to edit the PgBouncer maxpreparedstatements configuration parameter, as it has a direct impact in the latency of the consumers of the database through the pool.
Also, the default setting of 100 max prepared statements that Aiven has in the system is incorrect and will cause issues with ORM users when they upgrade the pgbouncer version in Aiven.
https://github.com/prisma/prisma/issues/21531#issuecomment-1794539086
Moreno Antunes
shared this idea
-
As PG developer,
I want to use this new feature in pgbocuner 1.22.0
"support for the DISCARD ALL and DEALLOCATE ALL commands when enabling prepared statement support in transaction pooling mode (by setting max_prepared_statements to a non-zero value). This is an important improvement in the prepared statement support that clears the road for us to be able to enable prepared statement support by default in a future release."
https://www.pgbouncer.org/2024/01/pgbouncer-1-22-0
