Unlisted PgBouncer Server - Flexible PostgreSQL Parameter

Luis Martins - Docspider Software 41 Reputation points
2022-08-24T19:47:46.737+00:00

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.

234692-image.png

234662-image.png

Att,
Luis Ricardo Martins - IT Analyst Docspider

Azure Database for PostgreSQL
{count} votes

Answer accepted by question author
  1. GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator
    2022-08-24T21:48:20.007+00:00

    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.

    234655-image.png

    I tried from my end and I don't see any issues
    234663-image.png

    Regards
    Geetha

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Luis Martins - Docspider Software 41 Reputation points
    2022-08-25T13:47:25.353+00:00

    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!

    234860-image.png


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.