DEMO 10X Faster Analytics Queries on Postgres with Citus

In this demo, database engineer Samay Sharma of Citus Data compares the performance of queries for a Citus database cluster vs. single-node Postgres. Samay explains how the Citus extension to PostgreSQL shards your data and transforms Postgres into a distributed database—to deliver performance at scale for both multi-tenant SaaS applications & customer-facing, real-time analytics dashboards.

Samay shows how query performance scales linearly with the size of the Citus database cluster, looks at PostgreSQL EXPLAIN plans generated by the query planner, and explores how Citus improves query performance by 10X or more, with just a small 4-node Citus database cluster.

Learn more about how Citus scales out PostgreSQL horizontally. Citus is available as open source, as enterprise software you can run anywhere, and as a fully-managed database as a service:

See how enterprises and SaaS businesses use Citus to scale out Postgres 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 database and real-time analytics use cases:

[mylist]

If you don't define any distribution function that table will work as local table and data store into coordinator node. I can see coordinator node resource configuration less compare to worker nodes .Could you please share the results if coordinator and worker node both with same config.

[DevOpsKey]

Please share a video on Citus cluster with complete detail.