What looks compelling about the PostgreSQL offering as compared to AWS RDS is that it looks like you get a PostgreSQL cluster rather than a single database in a shared cluster. At least reading the documentation for creating a DB implies that (<a href="https://docs.microsoft.com/en-us/azure/postgresql/quickstart-create-server-database-azure-cli" rel="nofollow">https://docs.microsoft.com/en-us/azure/postgresql/quickstart...</a>).<p>For me, it might remove some blockers to moving some clients to a cloud managed database solution that had always been there with AWS RDS. If that follows through and pays off for having a proper PostgreSQL super user in the database environment available for use (what I really want), that can make certain things much more do-able (brings new things you have to watch out for, too, but... pick your battles).
Unfortunately, still not available in the India datacenter.<p>This is going to be huge in India. Microsoft has massive mindshare in India with the govt because of the regulatory landscape.<p>I have it on firsthand info that several banks in India are going to make their <i>first ever</i> transition to the cloud on Azure because of Microsoft's willingness to go the extra mile around whatever security dances that the banks want them to do.<p>Plus Azure has India datacenter which takes of the PII problem for healthcare and financial data.<p>It is truly unfortunate that the management console has the worst UX ever.
Microsoft azure product links for those looking:<p>MySQL: <a href="https://azure.microsoft.com/en-us/services/mysql/" rel="nofollow">https://azure.microsoft.com/en-us/services/mysql/</a><p>PostgreSQL: <a href="https://azure.microsoft.com/en-us/services/postgresql/" rel="nofollow">https://azure.microsoft.com/en-us/services/postgresql/</a>
Better late than never - this is a welcome alternative to Amazon's RDS support for postgresql, the lack of which has been the primary reason I've kept personal workloads off of Azure. I'm excited to take this for a spin!<p>Azure SQL Server has been great at work; operationally, it couldn't be simpler, and the point-in-time restore feature saved our bacon at least once. The only drawback has been... SQL Server itself. It's a solid performer, but T-SQL is a bear to work with. If MSFT can apply the same operations magic to postgres, they'll have a real winner on their hands.
Please add/vote what are most critical PostgreSQL extensions you want to have in Azure Database for PostgreSQL. <a href="https://feedback.azure.com/forums/597976-azure-database-for-postgresql" rel="nofollow">https://feedback.azure.com/forums/597976-azure-database-for-...</a>
This is absolutely great news.<p>Just a word of warning, plv8 extension isn't available in the preview:<p><a href="https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions" rel="nofollow">https://docs.microsoft.com/en-us/azure/postgresql/concepts-e...</a><p>Apart from the lack of that extension, ah so exciting. <3 PostgreSQL.
Wow. If someone had suggested this would happen last year, I would have said pigs would fly first.<p>/me looks outside for flying pigs. Yep, there they are, whole groups of them going by in formation. ;)
Just a word of caution: be very careful to check the latency between the DB tier and the VM tier.<p>We had to abandon a multi-month deployment to Azure because the latency was too high and it caused all sorts of issues with our app. To be honest, our DB access approach wasn't great (heaps of really small requests), but we couldn't re-architect it in the timeframe we had. We were also doing this in Sydney, so maybe it was just a localised issue (the Australian data centres are relatively new).<p>Anyway, hopefully they have that sorted - we need more competition!
Please read my blog about Azure Database for PostgreSQL here -<a href="https://azure.microsoft.com/en-us/blog/announcing-azure-database-for-postgresql-preview/" rel="nofollow">https://azure.microsoft.com/en-us/blog/announcing-azure-data...</a>
/<i>I work at Microsoft on the managed PostgreSQL service</i>/
Here are the pricing links<p><a href="https://azure.microsoft.com/en-us/pricing/details/postgresql/" rel="nofollow">https://azure.microsoft.com/en-us/pricing/details/postgresql...</a><p><a href="https://azure.microsoft.com/en-us/pricing/details/mysql/" rel="nofollow">https://azure.microsoft.com/en-us/pricing/details/mysql/</a>
So is a "compute unit" the same as the "Azure Compute Units" that are used to measure VMs? 800 ACU roughly comes out to 4 cores. At $0.78/hr, that is hardly comparable to the RDS offerings. Didn't see an indication of memory.<p>Much like SQL Server DTUs and DWUs, the spacebucks measurements only seem to useful for hiding the actual price comparisons.<p>At least they stopped the DTU/DWU non-sense for these services.
The landing page says "With Azure Database for PostgreSQL, you can scale the performance of your database with no application downtime". I don't see an option to scale the Postgres database in my Azure Portal.<p>Is this feature not available yet?
A quick try show me that it's very very slow... Like 1s for a very simple query on a quite small database.
I tried from a scaleway server (in France).