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

1. View Slide

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
   

   View Slide

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.
   

   View Slide

4. Scaling out PostgreSQL
   in Azure
   

   View Slide

5. View Slide

6. Azure Database for PostgreSQL
   Hyperscale - Azure Arc
   Demo
   

   View Slide

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

   View Slide

8. Backup Slides / Notes
   

   View Slide

9. Flow
   2
   3
   3
   10
   3
   3
   1
   20
   

   View Slide

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.
    

    View Slide

11. © Microsoft Corporation
    Azure Database for PostgreSQL Hyperscale (Citus)
    Azure Data Services
    

    View Slide

12. © Microsoft Corporation
    Azure Database for PostgreSQL Hyperscale - Azure Arc
    Azure Data Services
    Azure Data Services – Azure Arc
    

    View Slide