Schedule - PGConf NYC 2023

The future of connection pooling: PgBouncer or something else?

Date: 2023-10-05
Time: 14:00–14:50
Room: Club Parlor
Level: Intermediate

Postgres its connection pooler landscape is constantly changing: PgBouncer now supports named prepared statements in transaction pooling mode! New connection poolers with other fancy features like sharding and clustering are popping up too. So, now is a good time to reconsider your choice of connection pooler.

But do you really need to switch and if so which pooler do you choose?

• Simply the pooler already provided by the Postgres client library for your programming language of choice?
• The tried and tested PgBouncer?
• Or, one of the new kids on the block, like Odyssey, PgCat, or Supavisor?

In this talk you'll learn:

1. How some of the major new PgBouncer features work and how these features can be useful to you. The new named prepared statement functionality will be covered in detail.
2. What the differentiating factors are between PgBouncer, Odyssey, PgCat, and Supavisor. So you can decide for yourself which of these is best for you.

Speaker

Jelte Fennema-Nio