Poor performance, even when increasing compute size
Hello! I've recently launched a website with a friend of mine, but we've been running into some issues recently with our Neon database.
Just yesterday our site was running fine, but now there seems to be an issue with Neon's response times. We've recently upgraded to Pro to try and solve the problem, but it hasn't helped.
Changing the compute size seems to help for a few minutes, so I don't believe it's a problem with inefficient queries, but after a few minutes the performance decreases significantly. We're currently using 2 vCPU, 8 GB of RAM, which is way more than we'd expect to need.
1 Reply
unwilling-turquoise•2y ago
These issues are always tricky to work through.
Is the load on your site consistent?
Are you using connection pooling to avoid opening too many connections?
Has a vacuum been run to clean up your tables?
Are you closing transactions? Using
pg_stat_activity might help track these down and looking at wait_event.
You could create a new branch to test some of this in isolation from your main branch/site. Using EXPLAIN ANALYZE might provide some insight.
We plan to expose more observability features in the future so you can more easily identified where you're hitting resource constraints, but for now you could contact support and ask them to take a look for you.