Scale storage performance

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

This article provides step-by-step instructions to perform scaling operations of the performance related aspects of the storage attached to an Azure Database for PostgreSQL flexible server.

If your server is using Premium SSD disk, you can use a performance tier higher than the original baseline to meet higher demand. The baseline performance tier is set based on the provisioned disk size. For more information, see Performance tiers for managed disks.

If your server is using Premium SSD v2 disk, you can also adjust, independently, the IOPS and throughput of your disk. For more information, see Premium SSD v2 performance.

Steps to scale storage performance tier (Premium SSD)

Important

If you increase the performance tier of your disk, you can only decrease it to a lower tier 12 hours after the last increase. This restriction is in place to ensure stability and performance after any changes to your server's configuration.

Any attempt to decrease the performance tier within the 12 hours after increasing it, produces the following error:

Code: PerformanceTierCannotBeDowngradedBefore12HoursError
Message: Unable to downgrade storage tier: A higher tier was explicitly set on the server at <mm/dd/yyyy hh:mm:ss AM|PM +00:00>. Tier can only be downgraded after 12 hours

Portal

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. In the resource menu, select Compute + storage.

   

3. If you want to increase the performance tier of the disk allocated to your server, expand the Performance Tier drop-down and select the tier that suits your needs. Smallest tier that can be assigned to a disk, depends on the allocated size of the disk. That smallest tier is referred to as the baseline performance tier of a disk of that size. If you increase the performance tier, you're increasing the maximum IOPS and throughput of the disk. To learn about the baseline performance tiers set for each size of a disk, and the tiers to which you can upgrade, see what Premium SSD disk performance tiers can be changed.

   

4. Select Save.

   

5. A notification shows that a deployment is in progress.

   

6. When the scale process completes, a notification shows that the deployment succeeded.

   

CLI

You can initiate the scaling of your storage, to increase the performance tier of your Premium SSD disk, via the az postgres flexible-server update command.

az postgres flexible-server update --resource-group <resource_group> --name <server> --performance-tier <performance_tier>

Note

The previous command might need to be completed with other parameters whose presence and values would vary depending on how you want to configure other features of the existing server.

The allowed values that you can pass to the --performance-tier parameter depend on the size of the disk.

If you pass an incorrect value to --performance-tier, you get the following error with the list of allowed values:

Incorrect value for --performance-tier for storage-size: <storage_size>. Allowed values : ['<performance_tier_1>', '<performance_tier_2>', ..., '<performance_tier_n>']

You can determine the performance tier currently set for the storage of your server via the az postgres flexible-server show command.

az postgres flexible-server show --resource-group <resource_group> --name <server> --query storage.tier

Steps to scale storage IOPS (Premium SSD v2)

Portal

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. In the resource menu, select Compute + storage.

   

3. If you want to change the IOPS assigned to the disk allocated to your server, type the desired value in the IOPS (operations/sec) text box. Range of IOPS that can be assigned to a disk, depends on the allocated size of the disk. To learn more about it, see Premium SSD v2 - IOPS.

   

4. Select Save.

   

Important

The operation to change the IOPS assigned to Premium SSD v2 disks is always performed as an online operation, which doesn't produce any downtime of your server.

5. A notification shows that a deployment is in progress.

   

6. When the scale process completes, a notification shows that the deployment succeeded.

   

CLI

You can initiate the scaling of your storage, to change the IOPS of your Premium SSD v2 disk, via the az postgres flexible-server update command.

az postgres flexible-server update --resource-group <resource_group> --name <server> --iops <iops>

Note

The previous command might need to be completed with other parameters whose presence and values would vary depending on how you want to configure other features of the existing server.

The allowed range of values that you can pass to the --iops parameter depend on the size of the disk.

If you pass an incorrect value to --iops, you get the following error with the allowed range of values:

The requested value for IOPS does not fall between 3000 and <maximum_allowed_iops> operations/sec.

You can determine the IOPS currently set for the storage of your server via the az postgres flexible-server show command.

az postgres flexible-server show --resource-group <resource_group> --name <server> --query '{"storageType":storage.type,"iops":storage.iops}'

Steps to scale storage throughput (Premium SSD v2)

Portal

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. In the resource menu, select Compute + storage.

   

3. If you want to change the throughput assigned to the disk allocated to your server, type the desired value in the Throughput (MB/sec) text box. Range of throughput that can be assigned to a disk, depends on the size of the disk and the IOPS assigned. To learn more about it, see Premium SSD v2 - Throughput.

   

4. Select Save.

   

Important

The operation to change the throughput assigned to Premium SSD v2 disks is always performed as an online operation, which doesn't produce any downtime of your server.

5. A notification shows that a deployment is in progress.

   

6. When the scale process completes, a notification shows that the deployment succeeded.

   

CLI

You can initiate the scaling of your storage, to change the throughput of your Premium SSD v2 disk, via the az postgres flexible-server update command.

az postgres flexible-server update --resource-group <resource_group> --name <server> --throughput <throughput>

Note

The previous command might need to be completed with other parameters whose presence and values would vary depending on how you want to configure other features of the existing server.

The allowed range of values that you can pass to the --throughput parameter depend on the size of the disk and the IOPS configured.

If you pass an incorrect value to --throughput, you get the following error with the allowed range of values:

The requested value for throughput does not fall between 125 and <maximum_allowed_throughput> MB/sec.

You can determine the throughput currently set for the storage of your server via the az postgres flexible-server show command.

az postgres flexible-server show --resource-group <resource_group> --name <server> --query '{"storageType":storage.type,"throughput":storage.throughput}'

Related content

• Scale storage size.
• Storage options.
• Limits in Azure Database for PostgreSQL - Flexible Server.