my postgresSQL, server parameters dont have pgbouncer

Question

why my azure postgresSQL, server parameters dont have pgbouncer to enable...

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-pgbouncer?WT.mc_id=Portal-Microsoft_Azure_Support

Answer 1

Hi @rui dias , welcome to Microsoft Q&A forum.

It seems you are not able to locate pgbouncer in server parameters in Azure PostgreSQL server.

If you have created Azure PostgreSQL - Single Server, this parameter is not available. You can check this as mentioned in below screenshot with yellow highlighted box:

PGBouncer is available as a built-in option for Azure Database for PostgreSQL – Flexible Server. It is supported on General Purpose and Memory Optimized compute tiers in both public access and private access networking.

As mentioned in the below screenshot it is available:

PgBouncer in Azure Database for PostgreSQL - Flexible Server

Please let us know if this helps or else we can discuss further on the same.

----------

If answer is helpful please please click on as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions. Thank you for helping to improve Microsoft Q&A!

Answer 2

that's it
I think now I can't update, I have to create a flexible one and migrate data...

i need pgbouncer because it seems that in azure the connection to the db in the webapp takes more than 15 seconds because of the azure proxy, and I don't see the metrics too high and it doesn't matter if it's 1 user or 1000....

i have 2 vCores 1700 iops, and a p2v2 webapp php linux, and a search for 100reg takes 30 seconds, which on my local server takes 1 second

hope this helps or give up on Azure managed services

Answer 3

why i can see pgbouncer enabled setting in azure