Presented by:

1685466376482

Jonah Harris

NEXTGRES

Jonah is a long-time developer focused on database internals, high-performance systems, compatibility methods, network protocols, and near-real-time machine learning optimizations. He specializes in data structures, algorithms, and software optimization. In addition to being a recognized expert in Oracle Database, he is also a longstanding PostgreSQL contributor who has served as the CTO of MariaDB (NYSE) and The Meet Group (NASDAQ), and was a founding engineer at EnterpriseDB.

No video of the event yet, sorry!

Managing high volumes of connections in PostgreSQL is critical for optimal performance and scalability. Traditionally, PgBouncer has been the go-to external connection pooler, offering lightweight and efficient connection management. In this talk, we introduce a version of PgBouncer that extends its functionality, allowing it to run either standalone or directly within PostgreSQL as an in-database connection pooling extension. This dual-mode approach simplifies deployments, reduces latency, and opens up new possibilities for managing connections more efficiently. Attendees will explore the architecture, benefits, and use cases of this flexible solution, offering the best of both worlds—external and in-database pooling—to meet diverse performance and scalability needs. Alternative connection poolers will be discussed also.

Date:
Duration:
50 min
Room:
Conference:
Seattle 2024
Language:
Track:
Ops
Difficulty:
Medium