Back to Devoured - November 18, 2026
DEVOURED
Set storage IOPS and throughput when restoring Postgres backups

Set storage IOPS and throughput when restoring Postgres backups

DevOps PlanetScale
PlanetScale now allows users to explicitly configure storage IOPS and throughput when restoring Postgres backups to a new branch.
What: Users can now accelerate large Postgres restores by setting custom performance limits via the CLI flag --storage-iops or through the dashboard without needing to upgrade the entire cluster tier.
Why it matters: Giving developers granular control over storage performance during data-intensive operations reduces the need to over-provision resources, managing costs for temporary operational tasks.
Takeaway: If you are performing large database restores on PlanetScale, use the --storage-iops and --storage-throughput flags to decrease restore time.
Decoder
  • IOPS (Input/Output Operations Per Second): A standard metric to measure the performance of a storage device.
  • Throughput: The amount of data that can be transferred between storage and application per unit of time.
Original article

Set storage IOPS and throughput when restoring Postgres backups

Postgres backup restores will now let you set storage IOPS and throughput for the new branch. Large restores are often limited by disk throughput, so this lets you speed up a restore without choosing a bigger cluster size than the branch needs.

You'll find the new settings in the Restore to new branch dialog for branches on AWS network-attached storage. The settings stay on the restored branch, and you can change them later from its storage settings.

You can also set them from the CLI with --storage-iops and --storage-throughput:

pscale backup restore <DATABASE_NAME> <NEW_BRANCH_NAME> <BACKUP_ID> \
  --storage-iops 5000 --storage-throughput 300

Through the API, set storage_iops and storage_throughput_mibs in the storage object when you create a branch from a backup or a point in time.

Explore all 55 articles in today's digest

Fresh dev news, AI-digested daily. Never miss a trend at devoured.fyi