Home / Companies / Aiven / Blog / Post Details
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.