how to improve the azure PostgreSQL flexible server performance in cloud

@Kattekola Mahesh Thank you for reaching out.

The default maximum number of connections for your configuration (General Purpose, D8ds_v5, 8 vCores, 32 GiB RAM) is 3,422 user connections.

When you first set up your Azure Database for Postgres flexible server instance, it automatically decides the highest number of connections that it can handle concurrently. This number is based on your server's configuration and can't be changed.

However, you can use the max_connections setting to adjust how many connections are allowed at a particular time. After you change this setting, you need to restart your server for the new limit to start working. https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/concepts-limits

@Kattekola Mahesh We haven't heard back since my last comment.

You are experiencing an error when attempting the 11th connection, after successfully making 10 connections.

First, I would like to understand how the query is being executed, as in an 8 vCore SKU, you should not encounter this issue. We need to review this aspect first. Secondly, I would like to see the specific error message you are receiving.

Regards,

Oury