When you use AnalyticDB for PostgreSQL, the data size and computing workload may surge and the data processing speed may hit a bottleneck due to insufficient computing resources such as CPU, memory, disk space, and data processing nodes. To scale instances, AnalyticDB for PostgreSQL allows you to change instance specifications in the console. This topic describes how to scale an AnalyticDB for PostgreSQL instance in Serverless mode within seconds.

Prerequisites

An AnalyticDB for PostgreSQL instance is created. For more information, see Create an instance.

Add compute nodes

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select the region where the instance resides.
  3. Find the instance that you want to manage and click its ID.
  4. In the Database Information section of the Basic Information page, choose Change Compute Node Specifications > Add Compute Node.
  5. In the Info dialog box, select I am aware of the impact of this operation and agree to continue it. and click OK.
    Note After you submit the specification change request, the SQL statement that is being executed will be interrupted and cannot be resumed even after the change is made.
  6. On the Upgrade/Downgrade page, set the Nodes parameter to 4, read and select the Terms of Service, and then click Buy Now.
    Note Select the number of nodes based on your business requirements.
  7. Return to the Basic Information page and wait for the instance to change to the Running state.

Remove compute nodes

Note Only AnalyticDB for PostgreSQL instances in Serverless mode allow you to remove compute nodes.
  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select the region where the instance resides.
  3. Find the instance that you want to manage and click its ID.
  4. In the Database Information section of the Basic Information page, choose Change Compute Node Specifications > Remove Compute Node.
  5. In the Info dialog box, select I am aware of the impact of this operation and agree to continue it. and click OK.
    Note After you submit the specification change request, the SQL statement that is being executed will be interrupted and cannot be resumed even after the change is made.
  6. On the Upgrade/Downgrade page, set the Nodes parameter to 2, read and select the Terms of Service, and then click Buy Now.
    Note Select the number of nodes based on your business requirements.
  7. Return to the Basic Information page and wait for the instance to change to the Running state.

References

For more information about instance scaling, see Change the specifications of compute nodes.