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: https://www.citusdata.com/product See how enterprises and SaaS businesses use Citus to scale out Postgres 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 database and real-time analytics use cases: https://www.citusdata.com/use-cases/r...