Schedule - PGConf NYC 2024

Surpassing 100K Postgres Connections With An In-Database Connection Pooling Extension

Date: 2024-09-30
Time: 15:00–15:50
Room: The Forum
Level: Intermediate
Feedback: Leave feedback

High-traffic PostgreSQL databases face significant challenges with connection management, including high memory usage, substantial CPU resource consumption, and scalability constraints. Traditional external connection poolers like PgBouncer introduce latency and complexity. In-database connection pooling addresses these pain points by reusing existing connections, reducing resource consumption, and improving load management. This open source extension leverages PostgreSQL's extensible architecture, providing seamless integration and enhanced performance. Attendees will learn about the architecture, benefits, and implementation of this solution, offering a scalable and efficient approach to handle large numbers of concurrent connections directly within Postgres.

Slides

The following slides have been made available for this session:

Speaker

Jonah H. Harris