I updated Compute Postgres to burstable B2S and still having only 50 max connections.

Question

I updated Compute Postgres to burstable B2S and still having only 50 max connections.

Audrius 0

Hi,

I'm using Azure Functions with Prisma ORM as a backend for REST API . There is a problem that it creates too many connections because every function creates separate connection to Postgres DB. So, I upgraded my plan to B2S so I can get 100 connections according Microsoft documentation but I still getting only 50.

1 answer

Your answer

Answer 1

GeethaThatipatri-MSFT 29,542 Microsoft Employee Moderator

Hi @Audrius Welcome to the Microsoft Q&A forum, Thanks for posting your question.

It's possible that the maximum number of connections is not being updated after you upgraded your plan. Have you tried restarting the Azure Postgres server to see if the new maximum connection limit is applied?

Can you share the result for this SHOW max_connections;

you can also change the max_connection from server parameters as shown below

User's image

Regards

Geetha

Audrius 0 Reputation points

2023-06-07T14:54:37.38+00:00

Hi,

It is set to 50, sorry I did not know that you need to update it manually. So you confirm that B2S plan supports 100 connections.

Do you have any solution how to minimize connections when using cloud functions as a rest api ? Prisma have suggestion to put connection_limit=1 in a connection string but it did not work somehow on azure.

https://www.prisma.io/docs/guides/performance-and-optimization/connection-management#serverless-environments-faas
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-06-09T13:04:23.9266667+00:00

@Audrius Use a connection pooler Performance best practices for using Azure Database for PostgreSQL – Connection Pooling | Azure Blog | Microsoft Azure

PgBouncer - Azure Database for PostgreSQL - Flexible Server | Microsoft Learn

pgbouncer helps by sharing connections to the database. you have to use the connection pooler (pgbouncer) for db connections. It won't work if you connect directly to db from the application.

Regards

Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-06-12T14:19:40.22+00:00

@Audrius We haven't heard back from you, If you think your question has been answered, click "Mark as Accept Answer",This can be beneficial to other community members reading this forum thread.

Regards

Geetha

Share via

I updated Compute Postgres to burstable B2S and still having only 50 max connections.

1 answer

Your answer