postgresqlamazon-web-servicesamazon-rdsprovisioned-iops

Increase Provisioned IOPS in RDS leads to downtime?

We have an m4.2x large RDS Postgres instance, with 300 GB storage and 1000 Provisioned IOPS.

We want to increase the PIOPS to 2000, will there be a downtime involved? If the performance will be downgraded, is there a measure by how much?

I could not find any relevant documentation talking about effects of increasing PIOPS on the instance while the change is taking place.

Thanks

Solution

  • There will be no downtime according to Amazon. Reference below.

    IOPS: The new Provisioned IOPS (I/O operations per second) value for the RDS instance. Changing this setting does not result in an outage and the change is applied during the next maintenance window unless the ApplyImmediately parameter is set to true for this request.

    Default: Uses existing setting

    Constraints: Value supplied must be at least 10% greater than the current value. Values that are not at least 10% greater than the existing value are rounded up so that they are 10% greater than the current value. If you are migrating from Provisioned IOPS to standard storage, set this value to 0. The DB instance will require a reboot for the change in storage type to take effect.

    ModifyDBInstance