Reputation: 4660
I have an app hosted on heroku and moved my DB to azure recently, because of the way SSL is handled by heroku postgres.
Even though my new Azure Postgres is plenty more potent than the former heroku:postgres equivalent, I am encountering severe slow downs.
I have setup PGBouncer to use connection pooling but I am still not seeing the the performance improve.
Any clues as to what I could try?
Upvotes: 0
Views: 269
Reputation: 10389
You're running into network latency issues between Heroku (which runs at AWS) and Azure. All your traffic has to go across the public internet between the two data centers.
Upvotes: 1