Using Postgres and Citus for Lightning Fast Analytics Queries

A demo to learn how you can use the Citus database to scale out Postgres and provide fast analytics queries. Using a 4-node Citus Cloud database cluster, this demo will show you how Citus shards Postgres to give you lightning fast performance, at scale.

-----------------------------------
Video bookmarks:

► 3:04 Why use Postgres and Citus for real-time analytics?

► 8:11 Demo of fast analytics queries with Postgres and Citus

► 23:40 Benefits of using Citus for demanding analytics workflows

► 25:24 How Heap Analytics uses the Citus database

► 26:29 How Microsoft uses Citus for their Windows telemetry data and VeniceDB

► 28:02 How Freshworks uses Citus for real-time chat analytics

-----------------------------------

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:

✅ Join the Citus database community’s public slack channel:

✅ Star the GitHub repo for the open source Citus database:

✅ Learn more about the Citus distributed database and how Citus scales out Postgres for real-time analytics dashboards:

[RamveerSingh]

I guess the fair comparison will be to compare citus with postgresql cluster of same no of nodes. Which is now just one node of postgresql and 4 nodes of citus database. Do you have a video on that as well. Also please make a video on scaling multi tenant postgresql instances using citus. Thanks