Running PostgreSQL at Scale on-premises and in the cloud | Microsoft Ignite 2019

Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

PostgreSQL is more popular than ever Creating the world's best PostgreSQL Uniquely delivering on all pillars of the open database platform Open source Proven resilience & stability Rich feature set Cloud management - anywhere Highly scalable • Add more nodes anytime • Limitless compute & memory • Scale cost-effectively • Built-in high availability • Security & compliance • Backups, monitoring Hyperscale (Citus) Azure Data Services – Azure Arc

Slide 3

Slide 3 text

What is Hyperscale (Citus)? Making PostgreSQL future-proof: Any scale. Grow to 100’s of database nodes, without re-architecting your application Block growth on 1 (monolithic) database vs.

Slide 4

Slide 4 text

Scaling out PostgreSQL in Azure

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

Azure Database for PostgreSQL Hyperscale - Azure Arc Demo

Slide 7

Slide 7 text

Join the Early Adopter Program https://aka.ms/hybrid-data-services

Slide 8

Slide 8 text

Backup Slides / Notes

Slide 9

Slide 9 text

Flow 2 3 3 10 3 3 1 20

Slide 10

Slide 10 text

Abstract: Postgres is the world's fastest growing open-source database. It runs in many places, including on Azure (through our Azure Database for PostgreSQL offering), and in your own data center on-premises. With the Hyperscale (Citus) technology, you can scale out Postgres to hundreds of terabytes of data, and accelerate your query performance through parallelism. We take a closer look at how we can utilize the Hyperscale (Citus) technology in different scenarios and walk through the use cases where you can accelerate and scale out your database.