Demo of Using Postgres & Citus for Lightning Fast Analytics Queries, also ft. Rollups

A demo to learn how you can use Citus to scale out Postgres and provide fast analytics queries. Using a 4-node Citus database cluster, this demo will show you how Citus shards Postgres to give you lightning fast performance, at scale. ----------------------------------- Video bookmarks: ► 1:45 Why use Postgres and Citus for real-time analytics? ► 4:12 Overview of the Citus Architecture ► 6:34 What are rollups and why are they useful ► 9:01 What is hll? ► 10:16 Demo of fast analytics queries with Postgres and Citus ► 25:19 Performance comparisons of Citus vs. single Postgres node ► 25:44 Benefits of using Citus for demanding analytics workflows ► 29:33 How Heap Analytics uses a 70-node Citus database cluster ► 30:19 How Algolia uses Citus for real-time search analytics ► 31:29 How Microsoft uses Citus for their Windows telemetry data and VeniceDB ----------------------------------- This demo of scaling out Postgres with the Citus extension to Postgres is useful for teams building customer-facing analytics dashboards who need to ingest data in real time while delivering sub-second responses; and for teams looking for a way to consolidate database platforms, to avoid having separate stores for your transactional and analytics workloads. Citus is available as a database as a service, as enterprise software, and as open source. ✅ See how enterprises and SaaS businesses use Citus for real-time analytics today: https://www.citusdata.com/customers/ ✅ Join the Citus database community’s public slack channel: https://slack.citusdata.com/ ✅ Star the GitHub repo for the open source Citus database: https://github.com/citusdata/citus ✅ Learn more about the Citus distributed database and how Citus scales out Postgres for real-time analytics dashboards: https://www.citusdata.com/product