pgbouncer for the masses

https://pdxpug.wordpress.com/2024/10/14/pdxpug-october-24th-pgbouncer-for-the-masses/

Pgbouncer is a popular tool for Postgres users at any scale. Over the years, it has become the go-to database proxy for Postgres. You’ll likely find pgbouncer at the heart of all kinds of production workloads. Recently, there have been some pretty exciting releases adding new exciting features for things like prepared statements.

In this talk we are going to take a look at how to get started with pgbouncer. We will introduce the concept of a database proxy, then we will go into the details of connection pooling, configuration, high availability, and using pgbouncer to scale Postgres connections.
If you’ve never used pgbouncer before, this talk is for you! If you have used pgbouncer for years, this talk is also for you too!