iTestee Database,Postgres Power of Indexes

Power of Indexes

  • Initially, we had not planned to create database indexes for code optimization, as developers typically focus less on such optimizations from the application side.
  • At first, CPU utilization reached over 87%.
  • After implementing the initial indexing, utilization dropped to 40–50%.
  • Following the second level of indexing, it has now reduced further to 30–40%.
  • With this improvement, we now have the opportunity to scale down the server to a lower tier, resulting in potential cost savings.

Leave a Reply

Your email address will not be published. Required fields are marked *

4 + 2 =
Powered by MathCaptcha

Related Post