Redrock Postgres Documentation
Home Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage
Edit page

Can I expand my storage online?

Description

When a running PostgreSQL server instance is about to run out of allocated storage space, we may face the following difficulties:

  • Due to the limitation of hardware capabilities, the server cannot dynamically add new storage devices and expand available storage space;
  • Because the migration operation of stored data is complex, excessive downtime is not allowed for upgrading local storage devices;

In this case, is there a viable way to quickly expand available storage space while the server instance continues running?

Answer

Redrock Postgres supports network attached tablespaces. Based on this capability, you can deploy a standalone storage server, create a network attached tablespace, transfer some table data into this new tablespace. Finally, you have expanded storage capacity online.