PgBouncer 1.21 adds prepared statement support in transaction mode

*Find the article on our blog here:* https://pganalyze.com/blog/5mins-postgres-pgbouncer-prepared-statements-transaction-mode

Today, we're going through the new PgBouncer 1.21 release which adds prepared statement support for PgBouncer when running in transaction mode. We talked about this previously in episode 73 of 5mins of Postgres a couple months ago and now this is actually released in a production version of PgBouncer. We feature @gregsabinomullane9036 and @JelteFennema.

*Learn more about pganalyze:*

https://pganalyze.com

https://pganalyze.com/newsletter

https://twitter.com/pganalyze/

*Check out the pganalyze library for eBooks, webinars, and more:*

https://pganalyze.com/resources

📑 *What we have discussed in this episode of 5mins of Postgres:*

*5mins of Postgres E73: Speed up Postgres with transaction pooling with prepared statements*

https://pganalyze.com/blog/5mins-postgres-faster-queries-transaction-pooling-prepared-statements

*PgBouncer 1.21.0 released - Now with prepared statements! - on postgresql.org*

https://www.postgresql.org/about/news/pgbouncer-1210-released-now-with-prepared-statements-2735/

*Prepared Statements in Transaction Mode for PgBouncer - by Greg Sabino Mullane*

https://www.crunchydata.com/blog/prepared-statements-in-transaction-mode-for-pgbouncer

*Greg Sabino Mullane on Twitter/X*

https://twitter.com/turnstep

*PgBouncer*

https://www.pgbouncer.org/

*Support of prepared statements - PR on the PgBouncer repo on GitHub*

https://github.com/pgbouncer/pgbouncer/pull/845