Date: 2024-09-30
Time: 15:00–15:50
Room: The Forum
Level: Intermediate
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.