/plushcap/analysis/aiven/aiven-postgresql-connection-pooling

Aiven for PostgreSQLĀ® connection pooling

What's this blog post about?

Aiven for PostgreSQL now supports connection pools, which allow users to maintain a large number of connections to a database while keeping server resource usage low. Connection pooling is achieved through PGBouncer, which manages the database connection and can handle up to 5000 client connections per pool. This reduces the need for separate backend processes on the server, leading to lower resource usage and better overall performance. Aiven PostgreSQL supports three different operational pool modes: "session", "transaction", and "statement". Connection pooling is particularly useful when dealing with a high number of backend connections, as it helps manage resources more efficiently.

Company
Aiven

Date published
Dec. 21, 2016

Author(s)
Hannu Valtonen

Word count
1554

Hacker News points
None found.

Language
English


By Matt Makai. 2021-2024.