Error Index Tuning Azure Postgresql.
Applies to: Azure Database for PostgreSQL.
Date created: May 3, 2025.
Problem Description.
I have created an Azure Database for PostgreSQL Flexible Server with the
following configuration:
Type: Development
Burstable, B2s
2 vCores, 4 GiB RAM, 32 GiB storage, P4 (120 IOPS)
Geo-redundancy : Disabled
Then, I went to enabling Index Tuning as shown on the image below:

When I clicked on that blue button, the deployment failed.

The details of the failed deployment are the following.
{"code":"DeploymentFailed","target":"/subscriptions/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX/resourceGroups/rgPrueba/providers/Microsoft.Resources/deployments/UpdateIndexTuningPostgreSqlFlexibleServer_X",
"message":"At least one resource deployment operation failed. Please list
deployment operations for details. Please see https://aka.ms/arm-deployment-operations
for usage details.","details":[{"code":"ResourceDeploymentFailure","target":"/subscriptions/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX/resourceGroups/rgPrueba/providers/Microsoft.Resources/deployments/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX-index_tuning.mode",
"message":"The resource write operation failed to complete successfully, because
it reached terminal provisioning state 'Failed'."}]}
Cause.
Index tuning feature is supported only on Azure Database for PostgreSQL Flexible
Server primary instances having at least 4 vCores and running PostgreSQL major
version of 12 or later. My Flexible Server was configured with only 2 vCores.
Solution.
Let's upgrade the Flexible Server to 4 vCores or more.
Make a click on Configuration.

Now change the Compute Size to 4 vCores or more.

And click on Save.

You may have to restart the server to make the configuration changes effective.

Verify the deployment succeded.

Proceed now to enable Index Tuning on the Flexible Server again.

The deployment should now succeed.
