[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Error Index Tuning Azure Postgresql

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

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.





 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.