AWS Aurora Postgres Optimization

Job ID: 38545853

Budget: ₹1,500 – ₹12,500 INR

I am experiencing high write IOPS on one of my AWS Aurora Postgres instances, and I need help resolving this issue. Despite having an index on a specific query, this instance is utilizing between 18,000 to 25,000 write IOPS with a response time of 163 milliseconds.

Key Points:
- The queries running on this instance are primarily read-heavy.
- My biggest concern is the query execution time.
- There have been no recent changes to the database configuration or schema

Your expertise in AWS Aurora, Postgres, database optimization, and performance tuning will be crucial for this project. I am aiming for a significant reduction in write IOPS and an overall improvement in query execution time.