Can I expand my storage online?
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?
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.