Configure intelligent tuning for Azure Database for PostgreSQL - Flexible Server by using the Azure portal
APPLIES TO: Azure Database for PostgreSQL - Flexible Server
This article provides a step-by-step procedure to configure intelligent tuning in Azure Database for PostgreSQL flexible server by using the Azure portal.
To learn more about intelligent tuning, see the overview.
Important
Autovacuum tuning is currently supported for the General Purpose and Memory Optimized server compute tiers that have four or more vCores. The Burstable server compute tier isn't supported.
Steps to enable intelligent tuning on your flexible server
Visit the Azure portal and select the Azure Database for PostgreSQL flexible server instance on which you want to enable intelligent tuning.
On the left pane, select Server parameters and then search for intelligent tuning.
The pane shows two parameters:
intelligent_tuning
andintelligent_tuning.metric_targets
. To activate intelligent tuning, changeintelligent_tuning
to ON. You have the option to select one, multiple, or all available tuning targets inintelligent_tuning.metric_targets
. Select the Save button to apply these changes.
Note
Both intelligent_tuning
and intelligent_tuning.metric_targets
server parameters are dynamic. That is, no server restart is required when their values are changed.
Considerations for selecting values for tuning targets
When you're choosing values from the intelligent_tuning.metric_targets
server parameter, take the following considerations into account:
The
NONE
value takes precedence over all other values. If you chooseNONE
alongside any combination of other values, the parameter is perceived as set toNONE
. This is equivalent tointelligent_tuning = OFF
, so no tuning occurs.The
ALL
value takes precedence over all other values, with the exception ofNONE
. If you chooseALL
with any combination, barringNONE
, all the listed parameters undergo tuning.The
ALL
value encompasses all existing metric targets. This value also automatically applies to any new metric targets that you might add in the future. This allows for comprehensive and future-proof tuning of your Azure Database for PostgreSQL flexible server instance.
Share your suggestions and bugs with the Azure Database for PostgreSQL product team.