All Products
Search

This Product

    AnalyticDB for PostgreSQL:Scale an instance

    Document Center

    AnalyticDB for PostgreSQL:Scale an instance

    Last Updated:Nov 30, 2023

    When you use AnalyticDB for PostgreSQL, the data size and computing workloads 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.

    Usage notes

    If you create indexes for an AnalyticDB for PostgreSQL instance in Serverless mode, the scaling performance of the instance is affected. The amount of time required for scaling is proportional to the data volume of indexes.

    Add compute nodes

    1. Log on to the AnalyticDB for PostgreSQL console.
    2. In the upper-left corner of the console, select a region.

    3. Find the instance that you want to manage and choose Change Compute Node Specifications > Add Compute Node in the Actions column.

    4. 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.

    5. 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 compute nodes based on your business requirements.

    6. Return to the Basic Information page and wait for the instance to change to the Running state.

    Remove compute nodes

    1. Log on to the AnalyticDB for PostgreSQL console.
    2. In the upper-left corner of the console, select a region.

    3. Find the instance that you want to manage and choose Change Compute Node Specifications > Remove Compute Node in the Actions column.

    4. 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.

    5. 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 compute nodes based on your business requirements.

    6. 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 compute node configurations.