Connection limits per plan for Aiven for PostgreSQL®
By default, Aiven for PostgreSQL® instances limit the number of allowed connections to make sure that the database is able to serve them all.
max_connections defaults
Default values of the max_connections setting vary according to the service plan:
| Plan | Max connections |
|---|---|
| Free | 20 |
| Hobbyist | 25 |
| Startup/Business/Premium-4 | 100 |
| Startup/Business/Premium-8 | 200 |
| Startup/Business/Premium-16 | 400 |
| Startup/Business/Premium-32 | 800 |
| Startup/Business/Premium-64 and above | 1000 |
Aiven can utilize any number of the connections for managing the service.
Increase max_connections
This is a limited-release parameter. Contact your account team to confirm your eligibility.
To increase the number of allowed connection for your service, set the value of
the
max_connections
parameter.
You cannot decrease this parameter value when set.
Use connection pooling
When several clients or client threads are connecting to the database, Aiven recommends using connection pooling to limit the number of actual backend connections. Connection pooling is available in all Aiven for PostgreSQL Startup, Business, and Premium plans, and can be configured in the console.