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.
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 is not supported.
Steps to enable intelligent tuning on your flexible server
Visit the Azure portal and select the flexible server 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.metric_targets. To activate intelligent tuning, change
intelligent_tuningto ON. You have the option to select one, multiple, or all available tuning targets in
intelligent_tuning.metric_targets. Select the Save button to apply these changes.
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:
NONEvalue takes precedence over all other values. If you choose
NONEalongside any combination of other values, the parameter will be perceived as set to
NONE. This is equivalent to
intelligent_tuning = OFF, so no tuning will occur.
ALLvalue takes precedence over all other values, with the exception of
NONE. If you choose
ALLwith any combination, barring
NONE, all the listed parameters will undergo tuning.
ALLvalue encompasses all existing metric targets. This value will also automatically apply to any new metric targets that you might add in the future. This allows for comprehensive and future-proof tuning of your PostgreSQL server.