Aiven for PostgreSQLĀ® connection pooling
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
Language
English
Hacker News points
None found.