Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

Citus Data
November 05, 2019

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.

Citus Data

November 05, 2019
Tweet

More Decks by Citus Data

Other Decks in Technology

Transcript

  1. 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 full-size slide

  2. 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 full-size slide

  3. Scaling out PostgreSQL
    in Azure

    View full-size slide

  4. Azure Database for PostgreSQL
    Hyperscale - Azure Arc
    Demo

    View full-size slide

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

    View full-size slide

  6. Backup Slides / Notes

    View full-size slide

  7. Flow
    2
    3
    3
    10
    3
    3
    1
    20

    View full-size slide

  8. 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 full-size slide

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

    View full-size slide

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

    View full-size slide