What Microsoft is doing with Postgres & the Citus Data acquisition | PGConf EU 2019 | Utku Azman

Many people have asked us: “Why did Microsoft acquire Citus Data?” and “What do you plan to do with the Citus open source extension to Postgres?” Come join us to see the exciting work we are doing with Postgres and open source at Microsoft.

Transcript

1. View Slide

2. PostgreSQL is more popular than ever
   Microsoft | 100:17:7
   

   View Slide

3. 17,000,000
   Partners
   7,000,000,000
   People
   100,000
   Employees
   PostgreSQL is more popular than ever
   Microsoft | 100:17:7
   

   View Slide

4. Community fueled momentum
   30+ years
   of active
   development
   2 years in a row
   DBMS of the year
   (ranked by db-
   engines)
   Unmatched
   community support
   Fastest growing
   DB by popularity
   https://db-engines.com/en/ranking_trend/system/PostgreSQL
   Most
   extensible
   database
   Ecosystem
   

   View Slide

5. Azure Database for
   PostgreSQL is
   fully-managed, community
   PostgreSQL
   Global
   reach
   Security
   Scale up
   & out
   Built-in HA
   Compliance
   Intelligent
   performance
   Easy ecosystem
   integration
   Extension
   support
   Extensions
   JSONB
   Full text
   search
   Geospatial
   support
   Rich
   indexing
   

   View Slide

6. Performance
    Postgres 10,11
    Query Store
    Query Performance Insights
    Performance recommendations
    Restart option
    Dblink
    AKS pgBouncer sidecar
    Read replicas in same region
    Read replicas cross region
   Scalability
    Scale across general purpose, memory optimized
    16 TB storage
    Resource move
    New SKUs: 64 vcore general purpose, 32 vcore memory optimized
    Hyperscale (Citus)
   Intelligence
    Geo-restore
    Query Store
    Query Performance Insights
    Performance recommendations
    HypoPG
    plv8
    Resource Health Check
   Security
    VNet Service endpoints
    Advanced threat protection
    Compliance and Certifications
    pgaudit
   Available in all public cloud, China, and government clouds
   Twelve months of
   rapid progress
   

   View Slide

7. A growing community of happy customers
   

   View Slide

8. And our learnings …
   

   View Slide

9. And more, including:
   To the
   community
   With the
   community
   PostgreSQL contributions
   

   View Slide

10. INSTALLS (last 30 days)
    85K+
    QUERIES RUN (last 30 days)
    260K+
    

    View Slide

11. View Slide

12. View Slide

13. Using data and analytics to
    improve Windows customer
    experience
    

    View Slide

14. Azure Database for PostgreSQL: Aka.ms/azure-postgres
    Citus Community GitHub:
    Blog Aka.ms/azure-postgres-blog
    

    View Slide

15. 1-day, single track, community PostgreSQL conference
    San Francisco, CA
    CFP opening next week!
    JANUARY 21, 2020
    

    View Slide