Monthly updates for Azure Database for PostgreSQL: November 2019
Now in preview for East US and UK South regions only, Azure Database for PostgreSQL Single Server provides support for service health notifications for planned maintenance.
Effective January 1, 2020, the meter IDs and names of Azure Database for PostgreSQL and MySQL and MariaDB General Purpose -Large Scale Storage will change.
Azure Database for PostgreSQL is now generally available in the recently announced regions of Switzerland.
Now in general availability, user role management enables management of Postgres user roles on Hyperscale (Citus) server group nodes in addition to "citus" and other built-in roles.
Now in general availability, Hyperscale (Citus) supports a 64 vCore compute option in addition to the 4, 8, 16, and 32 vCore choices previously available.
Azure Database for PostgreSQL - Hyperscale (Citus)—High availability (HA) is now generally available
Now in general availability, HA allows for minimal database downtime by maintaining standby replicas of every node in a server group.
Azure Database for PostgreSQL Single Server reserved capacity is now available to reserve compute power for your existing and future PostgreSQL servers.
Azure Database for PostgreSQL–Single now has support for up to 16 TB of storage and up to 20,000 IOPS. With this functionality, you get five times more storage for database servers, as well as more than triple the available IOPS.
Active Directory integration for Azure Database for PostgreSQL single server.
Power BI now supports direct query for Azure Database for PostgreSQL, both single server and Hyperscale (Citus). With direct query support, data isn’t copied or pulled directly into Power BI, instead queries are pushed down to the database engine and results retrieved.
Azure Database for PostgreSQL - Hyperscale (Citus) is now generally available. Azure Database for PostgreSQL - Hyperscale (Citus) scales out Postgres horizontally and is ideal for multi-tenant and SaaS applications that are growing fast, as well as for real-time analytics apps that need sub-second response times across billions of rows.