Report this

What is the reason for this report?

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

Posted on February 22, 2024

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.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.