When CPU, memory, or cache becomes a bottleneck under growing data and computation loads, adjust the reserved resources for your AnalyticDB for PostgreSQL Serverless Pro instance without taking the instance offline.
Prerequisites
Before you begin, ensure that you have:
An AnalyticDB for PostgreSQL instance in Serverless Pro pattern
Impact on running queries
Changing reserved resources has different effects depending on the resource type:
| Resource | Upgrade | Downgrade |
|---|---|---|
| Reserved compute resources | Interrupts all running SQL statements immediately. Interrupted statements cannot be resumed. | Interrupts all running SQL statements immediately. Interrupted statements cannot be resumed. |
| Serverless cache space | Does not interrupt running SQL statements. | Not supported. |
Change reserved resources
Steps 1 through 3 are the same for both upgrade and downgrade.
Log on to the AnalyticDB for PostgreSQL console. In the upper-left corner, select the region where your instance is located.
On the Instances page, find the target instance. In the Actions column, choose Change Reserved Resource Configurations, and then click Upgrade Reserved Resources or Downgrade Reserved Resources.
In the Info dialog box, select I am aware of the impact of this operation and agree to continue it., then click OK.
Adjust resources on the configuration page:
To upgrade: On the Upgrade/Downgrade page, adjust Reserved Compute Resources and Serverless Cache Space as needed, then click Buy Now.
To downgrade: On the Downgrade page, adjust Reserved Compute Resources, then click Buy Now.
Downgrading Serverless cache space is not supported.
The change is complete when the instance status changes to Running.