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

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

This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hey @namnguyenshrimp,
I’m sorry to hear about the performance issues you’re experiencing with your upgraded Postgres instance. It’s quite perplexing to encounter a slowdown after upgrading to a seemingly more robust configuration.
Please reach out to our amazing support team who will be more than happy to assist you with your issue! :)
Besides that, here are some general tips on how to troubleshoot such performance issues:
Use EXPLAIN or EXPLAIN ANALYZE on your slow queries to understand if and how their execution plans have changed following the upgrade. It’s possible that the instance resizing led to changes in the query planner’s behavior.
Check if all your indexes are intact and consider reindexing if necessary. Also, ensure that auto-vacuuming is properly configured and running as expected, as this can impact performance.
Monitor the CPU, memory, and I/O usage of your new instance. Compare these metrics to those from before the upgrade. This can help identify any new bottlenecks.
Look for any locking issues or increased block reads/writes that might be contributing to the slowdown. Long-running locks, in particular, can severely impact performance.
If your application’s usage pattern has changed around the time of the upgrade (e.g., more concurrent connections or different types of queries), it might contribute to the observed performance issues.
Review application logs for errors or warnings that may indicate issues with database interactions.
Hope that helps!
- Bobby.