Storage autogrow in Azure Database for PostgreSQL - Flexible Server

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

This article describes how you can configure Azure Database for PostgreSQL server storage to grow without impacting the workload.

For servers with more than 1 TiB of provisioned storage, the storage autogrow mechanism activates when the available space is less than 10% of the total capacity or when the available space is less than 64 GiB. The smaller of the two is the value that determines when autogrow activates. Conversely, for servers with storage under 1 TiB, this threshold is adjusted to 20% of the available free space or 64 GiB. Again, picking the smaller of the two values.

As an illustration, take a server with a storage capacity of 2 TiB (greater than 1 TiB). In this case, the autogrow limit is set at 64 GiB. This choice is made because 64 GiB is the smaller value when compared to 10% of 2 TiB, which is roughly 204.8 GiB. In contrast, for a server with a storage size of 128 GiB (less than 1 TiB), the autogrow feature activates when there's only 25.8 GiB of space left. This activation is based on the 20% threshold of the total allocated storage (128 GiB), which is smaller than 64 GiB.

Note

Storage always doubles in size for premium disk SSD, and that doubles the storage cost. Only premium SSD V2 supports more granular disk size increase.

Enable storage autogrow for existing servers

Portal

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server instance.

2. In the resource menu, under the Settings section, select Compute + storage.

3. In the Storage section, enable the Storage Auto-growth checkbox.

4. Select Save to apply the changes.

   

5. A deployment initiates and, when it completes, a notification shows that auto grow is successfully enabled.

   

CLI

You can enable storage autogrow in an existing server via the az postgres flexible-server update command.

az postgres flexible-server update --resource-group <resource_group> --name <server> --storage-auto-grow enabled

Disable storage autogrow for existing servers

Portal

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server instance.

2. In the resource menu, under the Settings section, select Compute + storage.

3. In the Storage section, enable the Storage Auto-growth checkbox.

4. Select Save to apply the changes.

   

5. A deployment initiates and, when it completes, a notification shows that auto grow is successfully enabled.

   

CLI

You can enable storage autogrow in an existing server via the az postgres flexible-server update command.

az postgres flexible-server update --resource-group <resource_group> --name <server> --storage-auto-grow disabled

Enable storage autogrow during server provisioning

Portal

Using the Azure portal:

1. During provisioning of a new instance of Azure Database for PostgreSQL Flexible Server, in the Compute + storage section, select Configure server.

   

2. In the Storage section, enable the Storage Auto-growth checkbox.

   

CLI

You can enable storage autogrow while provisioning a new server via the az postgres flexible-server create command.

az postgres flexible-server create --resource-group <resource_group> --name <server> --storage-auto-grow disabled ...

Note

The command provided above needs to be completed with other parameters whose presence and values would vary depending on how you want to configure other features of the provisioned server.

Share your suggestions and bugs with the Azure Database for PostgreSQL product team.

Related content

• Limits in Azure Database for PostgreSQL - Flexible Server.