> ## Documentation Index
> Fetch the complete documentation index at: https://www.aptible.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# aptible db:modify

This command modifies existing [Databases](/docs/core-concepts/managed-databases/managing-databases/overview). Running this command does not cause downtime.

# Synopsis

```
Usage:
  aptible db:modify HANDLE [flags]

Flags:
  -e, --env string           Environment handle (alias)
      --environment string   Environment handle
      --iops int32           Provisioned IOPS
      --volume-type string   Volume type (gp2 or gp3)
```

<Note>The IOPS option only applies to GP3 volume.  If you currently have a GP2 volume and need more IOPS, simultaneously specify both the `--volume-type gp3` and `--iops NNNN` options.</Note>

<Note>The maximum IOPS is dependent on disk size and container profile and size. Disk size must meet a minimum ratio of 1 GB disk size per 500 IOPS. Use the following table to understand what container profiles and sizes can be used to meet your IOPS needs. These guidelines may change over time as existing instance types are retired and new ones are introduced.</Note>

<table>
  <thead>
    <tr>
      <th>Max IOPS</th>
      <th>Minimum Disk Size</th>
      <th>General Purpose (M)</th>
      <th>CPU-Optimized (C)</th>
      <th>Memory Optimized (R)</th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td>18750</td>
      <td>38GB</td>
      <td>512MB – 60GB</td>
      <td>n/a</td>
      <td>4GB – 60GB</td>
    </tr>

    <tr>
      <td>20000</td>
      <td>40GB</td>
      <td>n/a</td>
      <td>2GB – 30GB</td>
      <td>n/a</td>
    </tr>

    <tr>
      <td>30000</td>
      <td>60GB</td>
      <td>n/a</td>
      <td>n/a</td>
      <td>150GB, 240GB</td>
    </tr>

    <tr>
      <td>40000</td>
      <td>80GB</td>
      <td>153GB</td>
      <td>60GB</td>
      <td>368GB</td>
    </tr>

    <tr>
      <td>60000</td>
      <td>120GB</td>
      <td>240GB</td>
      <td>n/a</td>
      <td>496GB</td>
    </tr>

    <tr>
      <td>80000</td>
      <td>160GB</td>
      <td>n/a</td>
      <td>150GB - 368GB</td>
      <td>752GB</td>
    </tr>
  </tbody>
</table>