How to Resize PostgreSQL Database Clusters

PostgreSQL is an open source, object-relational database built with a focus on extensibility, data integrity, and speed. Its concurrency support makes it fully ACID-compliant, and it supports dynamic loading and catalog-driven operations to let users customize its data types, functions, and more.

You can resize existing PostgreSQL database clusters at any time to add more CPUs, RAM, and storage. To avoid data loss, you cannot decrease the size of database clusters.

To resize a PostgreSQL database cluster, click the name of the cluster in the control panel to go to its Overview page, then click the Settings tab.

In the Cluster configuration section, click the Edit button. Select the MACHINE TYPE, NODE PLAN, and the number of STANDBY NODES (optional) for your configuration.

Cluster configuration section with additional nodes selected

Once you have selected your new configuration, click Save to provision the new configuration. The provisioning takes several minutes but the total time depends on the size of the cluster.

Your cluster’s state changes from Active to Resizing until the process is done. You can expect no downtime and do not need to take action.