I'm setting up a database server via AWS EC2, using:
- Root EBS Volume, General-purpose SSD
- EBS Volume, Provisioned IOPS
And intending to configure PostgreSQL to have the database and log files on the PIOPS volume.
I'm wondering how much IOPS strain that the root volume will have, since the base install of the DB engine and instance will be there, hence still handling the flow of data for the networking and database logic.
For example, if I have 2000 IOPS on the DB volume and 3 IOPS on the root volume, that database server would certainly be bottlenecked by the root IOPS. What does a good ratio look like?