Increased flexibility for Aiven for PostgreSQL® advanced parameters

You can now decrease several key advanced parameters for Aiven for PostgreSQL® that were previously restricted to increase only. This allows for better resource allocation and fine-tuning of your database instances as your workloads change.

The following parameters can now be adjusted both up and down:

• max_connections
• max_locks_per_transaction
• max_prepared_transactions
• max_wal_senders
• max_worker_processes

Decreasing these parameters typically requires a service restart to apply the changes. Ensure you have a maintenance window or high-availability (HA) enabled before proceeding.

Learn more

Check out the full list of Aiven for PostgreSQL advanced parameters in our documentation for details on default values and limits.