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

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.

Transcript

2. 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
3. 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.
4. Scaling out PostgreSQL in Azure
6. Azure Database for PostgreSQL Hyperscale - Azure Arc Demo
7. Join the Early Adopter Program https://aka.ms/hybrid-data-services
8. Backup Slides / Notes
9. Flow 2 3 3 10 3 3 1 20
10. 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.
11. © Microsoft Corporation Azure Database for PostgreSQL Hyperscale (Citus) Azure Data Services
12. © Microsoft Corporation Azure Database for PostgreSQL Hyperscale - Azure Arc Azure Data Services Azure Data Services – Azure Arc