Skip to main content
Scale a PostgreSQL cluster
Last update:

Scale a PostgreSQL cluster

A PostgreSQL cloud database cluster can be scaled — for example, increase vCPU and RAM to improve cluster performance.

You can change a fixed node configuration to an arbitrary configuration or an arbitrary configuration to a fixed configuration, but only with more disk space. You can reduce or increase the number of vCPUs and RAM. Look at the list of PostgreSQL node configurations.

The process of changing the configuration depends on the availability of replicas:

  • if there are no replicas in the cluster — the master node will be stopped while the changes are applied and the cluster will be temporarily unavailable for reading and writing;
  • if there are replicas in the cluster — the cluster will be read and write accessible while the changes are applied. The replicas will be stopped one by one, and the configuration of each replica will be changed. The master note will then switch to one of the replicas, and the past master note configuration will change.

The configuration change time depends on the amount of data in the cluster.

For your information

If you have previously changed DBMS settings, they may reset after scaling. Learn more about PostgreSQL settings.

  1. In Control Panel, go to Cloud Platform → Databases.
  2. Open the cluster page → Settings tab.
  3. Click Scale Cluster.
  4. Select another fixed or arbitrary configuration. You can only select a configuration with more disk space. The amount of vCPU and RAM can be reduced or increased.
  5. Optional: increase the number of replicas in the cluster.
  6. Click Save.