Date: 2023-06-01
Time: 14:00–14:45
Room: DMS 1140
Level: Intermediate
PgBouncer is the most popular connection pooler for PostgreSQL. Its simplicity and low resource usage made it a powerful combination for scaling PostgreSQL-based solutions. In the 15 years of active development, the project evolves a lot (several important contributions in various areas from administration to monitoring) but there are many challenges to be overcome. These are exactly the topics that are covered in this talk.
This talk provides a brief introduction about PgBouncer and explores the current roadmap. Authentication and SSL/TLS are hot topics. Features like new authentication methods (such as LDAP and GSSAPI) and prepared statements support for transaction pooling mode are presented. Modernizing internal structures is a challenge to support the PostgreSQL of the future. Scalability, robustness, transparency and integration are terms commonly used by software architects to describe the desired features for a connection pooler. They must drive the development of PgBouncer.