Content Deep Dive
Aiven for PostgreSQL® connection pooling
Blog post from Aiven
Post Details
Company
Date Published
Author
Hannu Valtonen
Word Count
1,554
Language
English
Hacker News Points
-
Summary
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.