Sorry, was comparing my MongoDB Atlas charges vs what ScaleGrid would charge for PostreSQL on Azure.
If I compare PostreSQL vs MongoDB via ScaleGrid on Digital Ocean (for 3 node cluster in both cases, 2 cores, 4GB RAM) I see $140 vs $160, which does not sound like a big difference to me (also not a big difference compared with the $250 on MongoDB Atlas/Azure with more storage).
What I am not sure about PostreSQL though are these connection limits which I asked you about above, and how well it handles failovers from one node to another in case of VM failure, or simply maintenance etc.
of course, I am not aware of Digital Ocean's VM instance sizes, and whether their 2 core / 4 GB is fully dedicated/100% provisioned or burstable like in case of Azure ... if fully dedicated/not burstable then that would be a good cost advantage in favor of Digital Ocean, which is however anyway not a hosting provider I am looking at due to many other PaaS services we are after ..
Sorry, was comparing my MongoDB Atlas charges vs what ScaleGrid would charge for PostreSQL on Azure.
If I compare PostreSQL vs MongoDB via ScaleGrid on Digital Ocean (for 3 node cluster in both cases, 2 cores, 4GB RAM) I see $140 vs $160, which does not sound like a big difference to me (also not a big difference compared with the $250 on MongoDB Atlas/Azure with more storage).
What I am not sure about PostreSQL though are these connection limits which I asked you about above, and how well it handles failovers from one node to another in case of VM failure, or simply maintenance etc.
of course, I am not aware of Digital Ocean's VM instance sizes, and whether their 2 core / 4 GB is fully dedicated/100% provisioned or burstable like in case of Azure ... if fully dedicated/not burstable then that would be a good cost advantage in favor of Digital Ocean, which is however anyway not a hosting provider I am looking at due to many other PaaS services we are after ..
Azure seems to suffer huge issues with disc performance (post from Nov 10, 2020) bunnyshell.com/blog/aws-google-clo...
DigitalOcean trumps all of the big 3, but Azure stands out in a bad way.
Atlas IOPS stats for Azure confirm this.