Analyzing real-time data with Azure Database for PostgreSQL sash@microsoft.com iaclarke@microsoft.com

Scenario: Real-time Operational Analytics

Typical application requirements

Why Postgres for real-time operational analytics

PostgreSQL is more popular than ever loved wanted https://insights.stackoverflow.com/survey/2019?utm_source=so-owned&utm_medium=blog&utm_campaign=dev-survey-2019&utm_content=launch-blog https://db-engines.com/en/blog_post/76 https://db-engines.com/en/ranking_trend/system/PostgreSQL DBMS of the Year DB-Engines’ ranking of PostgreSQL popularity PostgreSQL is more popular than ever

Azure Database for PostgreSQL

High performance scale-out with Hyperscale (Citus) The benefits of Azure Database for PostgreSQL Intelligent performance optimization Flexible and open Fully managed and secure Single Server Hyperscale (Citus) NEW Build or migrate your workloads with confidence

Azure Database for PostgreSQL is available in two deployment options Single Server Fully-managed, single-node PostgreSQL Example use cases • Apps with JSON, geospatial support, or full-text search • Transactional and operational analytics workloads • Cloud-native apps built with modern frameworks Hyperscale (Citus) High-performance Postgres for scale out Example use cases • Scaling PostgreSQL multi-tenant, SaaS apps • Real-time operational analytics • Building high throughput transactional apps Enterprise-ready, fully managed community PostgreSQL with built-in HA and multi-layered security

Shard your Postgres database across multiple nodes to give your application more memory, compute, and disk storage Easily add worker nodes to achieve horizontal scale Scale up to 100s of nodes Scale horizontally across hundreds of cores with Hyperscale (Citus) Coordinator Table metadata Each node PostgreSQL with Citus installed 1 shard = 1 PostgreSQL table Sharding data across multiple nodes

Microsoft Windows relies on Citus for mission-critical decisions 6M+ queries per day 95%

Enlyft provides faster intelligence to their customers with Hyperscale (Citus)

Deploy end to end applications faster with Postgres and Azure Notification Hubs Event Hubs Raw Events In-database rollups Aggregations App Service 1 2 3 4 5 6 4 Hyperscale (Citus) Devices Browser Azure Databricks 7

PostgreSQL tips for real-time analytics apps • • • • • • • • •

Hands on Lab

Scenario: You = Cloud services provider helping businesses monitor their HTTP traffic

Hands on Lab

Let’s get started! https://aka.ms/ignite-WRK2006R

Other sessions you might be interested in… Session ID Day / Time Title Speaker(s) BRK3018 Tue 11/5 11:45 AM Building modern apps that scale to billions of events with Azure Database for PostgreSQL and Hyperscale (Citus) Umur Cubukcu BRK2065 Tue 11/5 1:00 PM Innovations to boost productivity with Azure-managed MySQL, Postgres, and MariaDB databases Sunil Kamath THR2124 Tue 11/5 4:20 PM Running Postgres at scale on-premises and in the cloud Lukas Fittl BRK2064 Wed 11/6 11:45 AM Why developers love Postgres Craig Kerstiens, Shyam Pitchaimuthu THR2120 Wed 11/6 1:50 PM Deploy an app in Azure Kubernetes and App Services with MySQL Manish Kumar THR2123 Wed 11/6 4:20 PM Why enterprises are moving from Oracle to Azure Postgres Saurabh Modi BRK3019 Thu 11/7 2:15-3:00 Migrate or build internet-scale applications using MySQL Jan Engelsberg, Sunil Kamath