This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 35%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Hi!
I'm using Azure's PostgreSQL Starter Resource Plan - Flexible Server. None of Microsoft's own supervisor alerts panel recommends enabling the PgBouncer parameter to improve the performance of the database, however, this parameter is not listed according to the attached images.
I've read the configuration manual, however, I didn't find a plausible answer to necessarily be in accordance with the configuration. Or understand why it is not showing up to be enabled.
Att,
Luis Ricardo Martins - IT Analyst Docspider
Good Morning! @GeethaThatipatri-MSFT
I switched to English to make it easier.
I'm using flexible server and these are the allocated features that are highlighted in the image. in this documentation I did not identify the reason why the parameter does not appear for this Postgres server option.
The doubt remains!
Hi @Luis Martins - Docspider Software Welcome to the Microsoft Q&A Platform, and thanks for your query.
Are you using burstable SKU? Pgbouncer is supported only with GP and MO. Please refer to this document for more information.
I tried from my end and I don't see any issues
Regards
Geetha
Good Morning! @GeethaThatipatri-MSFT
I switched to English to make it easier.
I'm using flexible server and these are the allocated features that are highlighted in the image. in this documentation I did not identify the reason why the parameter does not appear for this Postgres server option.
The doubt remains!
@Luis Martins - Docspider Software You are using burstable SKU, as I mentioned above, pgbouncer is not supported with that. See the documentation link I sent. If you want to use pgbouncer that is bundled with Flex, you have to upgrade to at least General Purpose SKU.
Please let me know if you need any additional information.
Regards
Geetha
ok, i got it now, thanks!
I think I'll have to redeploy to change the SKU...
@Luis Martins - Docspider Software Yes please try if it worked for you and if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.
Regards
Geetha
that's right, and there's no need to deploy, you can change the SKU right in Postgre's Azure dashboard.
@Luis Martins - Docspider Software yes that is correct