Temporarily Increase Managed Database Disk Size

Hello,

As of the time being, you cannot resize cluster nodes to smaller sizes as described in the docs here:

https://docs.digitalocean.com/products/databases/postgresql/details/limits/

Given the constraint that you can’t downsize a managed cluster once it has been upsized, here’s a couple of options you might consider:

1. You can create a temporary managed cluster, upsized to accommodate the additional data. Import the new month’s data into the temporary cluster, run your tests, and when you’re confident that everything works as expected, you can migrate the data from the temporary cluster to your primary cluster, replacing the old data. This avoids potential downtime and allows you to only incur the cost of the larger cluster for the period required to validate the new data.

2. If possible, consider updating the data incrementally rather than replacing the entire set each time. This may reduce your temporary storage requirements. It may require more complex data handling (like versioning of your data), but could be less costly in terms of resources.

3. Another option is to use an external storage solution (like the DigitalOcean Spaces) to temporarily store your data. You can validate the data while it’s in the external storage, then transfer it to your database once you’re ready to replace the old data.

As you mentioned, an option is to scale up to a larger cluster so that you would be able to store all of the data at all time.

Hope that this helps!

Best,

Bobby

Hi there,

In addition to what has already been mentioned here, you can now add scalable storage to managed database clusters as shown in this video here:

Best,

Bobby