Question

A SysOps administrator manages a self-hosted PostgreSQL database on an EC2 instance using a 500 GB gp2 EBS volume. During peak reporting periods, CloudWatch shows VolumeQueueLength spiking and application latency increasing, even though the volume is only 60% full. The team wants to improve consistent I/O performance while reducing storage cost. What is the MOST cost-effective way to meet the performance requirement?

Accepted Answer

Migrate the volume to gp3 and independently provision the required baseline IOPS and throughput above the free tier defaults

Answer

Increase the gp2 volume size to 2 TB so the baseline IOPS scale up with capacity

Answer

Migrate the volume to io2 Block Express and provision maximum IOPS to guarantee performance

Answer

Migrate the volume to an st1 throughput-optimized HDD to handle the reporting workload