Compute Optimized Instance type not available for Aurora PostgreSQL

Question

Hi Team,

I have an Aurora PostgreSQL instance running version **14.9** on a **db.r6g.2xlarge ** instance type (Memory-optimized). Recently, the server's CPU usage has increased to around **99.5%**. I have reviewed the database and indexes, and everything seems to be in order. As a result, I am considering changing the instance type to one from the Compute family. However, when attempting to modify the instance, I found that Compute instance types are not available.

The available options are:

1.Serverless V2
2.Memory-optimized Instances
3.Burstable Instances
4.Optimized Reads Classes

Would switching to the fourth option, Optimized Reads Classes, improve performance? Any suggestions would be appreciated.

Thanks,
Krishnakumar K

Deeksha · Answer

Evaluate the Workload: Determine whether your workload is CPU-bound or if there's a significant I/O component that could benefit from optimized reads. If your CPU is at 99.5% usage and you’ve optimized your queries and indexing, your workload might be CPU-bound rather than I/O-bound.

Vertical Scaling: Since Compute-optimized instances aren't available, you may consider scaling up within the memory-optimized family. Moving to a larger instance size within this family (e.g., db.r6g.4xlarge or higher) might provide the additional CPU resources you need.

Horizontal Scaling: If your workload allows, consider adding more read replicas. This can offload some of the read traffic, reducing CPU usage on the primary instance.

Serverless V2 Consideration: If your workload has fluctuating demand and you want to ensure CPU resources match demand, Serverless V2 could be an option. However, you would need to monitor it closely to ensure it meets your performance needs.

Database Optimization: Although you mentioned that the database and indexes are optimized, double-check for any long-running queries or tasks that might be consuming excessive CPU. Tools like AWS Performance Insights or native PostgreSQL tools can help identify such queries.

Compute Optimized Instance type not available for Aurora PostgreSQL

Relevant content