Architecting petabyte-scale analytics by scaling out Postgres on Azure with Citus | PyData Berlin | Alicja Kucharcyzk

Architecting petabyte-scale analytics by scaling out Postgres on Azure with Citus | PyData Berlin | Alicja Kucharcyzk

A story about powering a 1.5 petabyte internal analytics application at Microsoft with 2816 cores and 18.7 TB of memory in the Citus cluster.
The internal RQV analytics dashboard at Microsoft helps the Windows team to assess the quality of upcoming Windows releases. The system tracks 20,000 diagnostic and quality metrics, digests data from 800 million Windows devices and currently supports over 6 million queries per day, with hundreds of concurrent users. The RQV analytics dashboard relies on Postgres—along with the Citus extension to Postgres to scale out horizontally—and is deployed on Microsoft Azure.

024d6a0dd14fb31c804969a57a06dfbe?s=128

Citus Data

March 18, 2020
Tweet