Share via

Azure PostgreSQL database : Ideal server parameter setting

sappu solanki 66 Reputation points
2021-02-23T12:02:52.307+00:00

We have recently hosted "Azure Database for PostgreSQL". Resource specifications are as follows:
Tier: General Purpose
Family: Gen5
Cores: 4vCore
RAM: 20 GB

I am very new from DBA front, Can someone suggest ideal settings for "Server parameters" on Azure ?
Overall database size is 12 GB.

Azure Database for PostgreSQL
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. SUNOJ KUMAR YELURU 15,256 Reputation points MVP Volunteer Moderator
    2021-02-23T12:15:42.933+00:00

    Hi @sappu solanki
    In Azure Database for PostgreSQL, the list of parameters can be viewed and edited using the Azure portal or the Azure CLI.
    As a managed service for Postgres, the configurable parameters in Azure Database for PostgreSQL are a subset of the parameters in a local Postgres instance. Your Azure Database for PostgreSQL server is enabled with default values for each parameter on creation. Some parameters that would require a server restart or superuser access for changes to take effect cannot be configured by the user.

    Server Configuration
    Configure server parameters in Azure Database for PostgreSQL - Single Server via the Azure portal

    Customize server parameters for Azure Database for PostgreSQL - Flexible Server using Azure CLI

    71142-image.png

    If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.

  2. si li 20 Reputation points
    2023-05-31T01:28:16.22+00:00

    Look at Server Configuration, tune configurations you care about, such as shared_buffers, checkpoint_timeout, max_wal_size, min_wal_size .

    0 comments

Your answer

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