Hyperscale (Citus) on Azure Database for PostgreSQL | PostgreSQL User Group NL | Marco Slot

Transcript

1. Hyperscale (Citus) on Azure Database for PostgreSQL
   Principal Software Engineer
   Microsoft (Citus)
   

   View Slide

2. Citus Data joins the Microsoft family
   

   View Slide

3. N O W O P E N S O U R C E
   https://github.com/citusdata/pg_auto_failover
   pg_auto_failover
   Simple automatic failover for PostgreSQL
   

   View Slide

4. N O W I N P R E V I E W
   Azure Database for PostgreSQL
   Hyperscale (Citus)
   https://www.citusdata.com/product/hyperscale-citus/
   https://github.com/citusdata/citus
   

   View Slide

5. Typical workload:
   O(log N) operations (CRUD) 99% of operations
   O(N) operations (analytics, expiration, vacuum, ..) 1% of operations
   Databases: They grow up so fast
   1000 1000000000 2000000000
   Compute time
   Number of rows
   Compute time of operations as your database grows
   O(log N) O(N)
   

   View Slide

6. Scale out
   horizontally
   High
   performance
   Simplified
   infrastructure
   Stay current with
   PostgreSQL innovations
   Hyperscale (Citus) | Azure Database for PostgreSQL
   Worry-free PostgreSQL in the cloud with an architecture that is built to scale out
   Optimized for multi-tenant, SaaS applications and real-time
   operational analytics.
   

   View Slide

7. View Slide

8. View Slide