ApsaraDB RDS:Configure automatic storage expansion for an ApsaraDB RDS for PostgreSQL instance

Usage notes

• After the storage capacity of your RDS instance is expanded, you cannot reduce the storage capacity of your RDS instance by changing the specifications of the instance. You can use the cloud migration feature to reduce the storage capacity. For more information, see Scale down an ApsaraDB RDS for PostgreSQL instance.
• Starting February 28, 2023, optimizations of the rules for automatic storage expansion are rolled out in different regions. If your RDS instance is a primary RDS instance and has read-only RDS instances, the system checks the storage capacity of each read-only instance when automatic storage expansion is triggered for the primary instance. If the storage capacity of a read-only instance is less than the required storage capacity of the primary instance after expansion, the system preferentially expands the storage capacity of the read-only instance. After the system expands the storage capacity of all read-only instances, the system expands the storage capacity of the primary instance. For more information, see [Notice] Optimization of automatic storage expansion for ApsaraDB RDS for MySQL instances and ApsaraDB RDS for PostgreSQL instances.

Billing

The billing rules for automatic storage expansion are the same as the billing rules for manual storage expansion of an RDS instance. For more information, see Specification change fees.

Procedure

1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
2. In the Usage Statistics section of the page that appears, click Settings to the right of Automatic Storage Expansion.
3. Configure the following parameters.

   Parameter	Description
   Automatic Resource Scalability	The switch that is used to enable or disable automatic storage expansion.
   Available Storage Threshold<=	The threshold based on which ApsaraDB RDS triggers an automatic storage expansion. The threshold is expressed as a percentage. If the storage usage reaches the threshold, ApsaraDB RDS increases the storage capacity of the RDS instance. Note The maximum amount of storage that you can increase is the larger value of the following values: 5 GB 15% of the current storage capacity of the RDS instance
   Maximum Storage	The maximum storage capacity that is allowed by automatic storage expansion. The value of this parameter must be greater than or equal to the current storage capacity of the RDS instance. If the RDS instance uses ESSDs, the maximum value of this parameter can be set to 32000 GB. If the RDS instance uses SSDs, the maximum value of this parameter can be set to 6000 GB.

4. Click OK.

View a storage expansion record

1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
2. In the Usage Statistics section, click Expansion history to the right of Automatic Storage Expansion to go to the Database Autonomy Service (DAS) console.
3. On the Autonomy Center page, set Type to Auto-Scaling Events to view the storage expansion records.
4. Click Details of the required scaling event to view the details of the storage expansion record.

Related operations