What is expected response time vs dedicated hosted Postgres?
At the moment I am doing some performance analysis of how Neon stacks up vs our existing Heroku Postgres DB. Looking at the stats it looks like Neon queries are taking can take 20ms to respond versus 1ms in Heroku, sometimes longer. Is this performance difference expected? Are there any recommendations to help improve the performance? I have the Neon DB start at 16GB on wake to mirror our Heroku instance to avoid autoscaling delays during processing. The performance seems consistent even trying to run the job again with an already running neon db. We do some jobs the requiring loads of queries and inserts its resulting in a 2x increase in the duration of our jobs.
0 Replies