Nota
El acceso a esta página requiere autorización. Puede intentar iniciar sesión o cambiar directorios.
El acceso a esta página requiere autorización. Puede intentar cambiar los directorios.
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.
Nota
Azure Database for PostgreSQL flexible server only supports the storage autogrow feature on storage type Premium SSD. 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.
Using the Azure portal:
Select your Azure Database for PostgreSQL flexible server.
In the resource menu, under the Settings section, select Compute + storage.
In the Storage section, enable the Storage autogrow checkbox.
Select Save to apply the changes.
A deployment initiates and, when it completes, a notification shows that autogrow is successfully enabled.
Using the Azure portal:
Select your Azure Database for PostgreSQL flexible server.
In the resource menu, under the Settings section, select Compute + storage.
In the Storage section, enable the Storage autogrow checkbox.
Select Save to apply the changes.
A deployment initiates and, when it completes, a notification shows that autogrow is successfully enabled.
Using the Azure portal:
During provisioning of a new Azure Database for PostgreSQL flexible server, in the Compute + storage section, select Configure server.
In the Storage section, enable the Storage autogrow checkbox.
