My Postgres instance slowed down by 50% after resizing to a larger instance.

Hi Digital Ocean team, I am writing to bring to your attention an issue I’ve encountered with our managed Postgres DB instance, specifically regarding its connection pool (22/47). Initially, the database was provisioned with a configuration of 1vCPU and 2GB RAM.

However, it became apparent that this setup was insufficient to adequately serve our application’s needs. Consequently, we upgraded the instance to 2vCPU/4GB RAM in an attempt to improve performance.

Unfortunately, rather than experiencing the desired enhancement, we observed a significant slowdown in performance, with a notable decrease of approximately 50%. For instance, a basic select query that previously took 8 seconds to complete now requires substantially more time.

Given the critical nature of this issue and its impact on our operations, I kindly request your immediate assistance in resolving it. Any insights, recommendations, or actions you can provide to optimize the performance of our Postgres DB instance would be greatly appreciated.

Thank you for your prompt attention to this matter.