Azure Database for PostgreSQL feature releases and blog posts over the past year

We’ve been hard at work on Azure Database for PostgreSQL over the past several months, with several new feature/functionality releases. We have also published numerous blog posts related to the service.

Features and functionality

Regarding our releases over the past several months, we’ve announced several new capabilities that provide critical steps toward enabling customers to more easily leverage the service, including:

• General Availability
  • Server storage to 4 TB
  • VNET Service Endpoint
  • Moving servers across subs.
  • 32 vCore MO, 64 vCore GP
  • Instant GraphQL with Hasura and PostgreSQL
  • TimescaleDB extensions
  • Intelligent Performance
    • Performance Recommendations
    • Query Store
    • Query Performance Insights
  • Same region Read Replica
  • PG extension: orafce (oracle compat) for PostgreSQL
  • Storage auto-grow option
  • Availability in South Africa regions
• Public Preview
  • Advanced Threat Protection
  • Data Operations Studio and VSCode extension for PostgreSQL
  • Hyperscale (Citus)
  • Read Replica across regions
  • 16TB/20K IOPS
  • PostgreSQL 11.0 support

Blog posts

Below is a consolidated list of the blog posts we published over the last year, in reverse chronological order:

• Jul 2019
  • Testing your Django apps with Citus
  • Improve Performance of Read Intensive Workloads on Axure DB for PostgreSQL using Query Caching
• Jun 2019
  • Steps to install and setup PgBouncer connection pooling proxy with Azure DB for PostgreSQL
  • Scale from Basic to General Purpose or Memory Optimized tiers in Azure Database for PostgreSQL
  • Create a master server and read replicas in Azure Database for PostgreSQL using the Azure CLI
• May 2019
  • Use orafce compatibility functions inside Azure Database for PostgreSQL
  • Operationalizing your PostgreSQL database health checks using SQL Notebooks
  • Get high-performance scaling for your Azure database workloads with Hyperscale
  • Introducing Hyperscale (Citus) on Azure Database for PostgreSQL
  • Managing multiple databases in Rails 6
  • pg_auto_failover: Open source extension for automated failover and high availability in PostgreSQL
  • Introducing pg_auto_failover: A high availability and automated failover Postgres extensionEntry
• Apr 2019
  • Optimize performance using Azure Database for PostgreSQL Recommendations
  • Bitnami Apache Airflow Multi-Tier now available in Azure Marketplace
  • Postgres and superuser access
• Mar 2019
  • Happy birthday to managed Open Source RDBMS services in Azure!
  • Securely monitoring your Azure Database for PostgreSQL Query Store
  • Power IoT and time-series workloads with TimescaleDB for Azure Database for PostgreSQL
  • Azure Data Studio: An Open Source GUI Editor for Postgres
  • Move to intelligent banking by embracing open APIs (Microsoft Industry Blogs)
• Feb 2019
  • Creating IoT applications with Azure Database for PostgreSQL
  • Use GraphQL with Hasura and Azure Database for PostgreSQL
  • Performance best practices for using Azure Database for PostgreSQL – Connection Pooling
• Jan 2019
  • Read Replicas for Azure Database for PostgreSQL now in preview
  • Microsoft and Citus Data: Providing the best PostgreSQL service in the cloud
  • Performance troubleshooting using new Azure Database for PostgreSQL features
• Nov 2018
  • Real-time event processing with Azure Database for PostgreSQL and Event Grid integration
  • Best practices for alerting on metrics with Azure Database for PostgreSQL monitoring
• Oct 2018
  • Announcing Azure database services for MySQL and PostgreSQL for Azure Government customers
• Sep 2018
  • Advanced Threat Protection for Azure Database for PostgreSQL in preview
  • Latest updates to Open Source Database Services for Azure – Ignite 2018
  • Join the Azure Open Source Database Engineering Team at Microsoft Ignite
  • Performance updates and tuning best practices for using Azure Database for PostgreSQL
• Aug 2018
  • Announcing VNet service endpoints general availability for MySQL and PostgreSQL
• Jul 2018
  • Latest updates to Azure Database for PostgreSQL

Note: For all blog posts related to Azure Database for PostgreSQL, see the following links:

• Azure Blog posts
• Tech Community posts

With several new features and additional service functionality in the pipeline, be sure to stay tuned for the latest updates!

The Azure Open Source Database Team