In this demo of the Citus database, engineer Marco Slot shines a light on the performance of the Citus extension to PostgreSQL, and the benefits of scaling out Postgres horizontally. Citus is available as open source, as a fully-managed database as a service, and as enterprise software that can be run on-prem or anywhere. Today Citus is often used by SaaS teams building multi-tenant applications, as well as developers building real-time analytics apps.
Marco showed the original version of this demo in a keynote at PostgresOpen Silicon Valley in late 2017. People found it so useful that we decided to retool it and share more broadly. The Citus database cluster that Marco creates to compare against a regular Postgres node is a 4-node Citus cluster with 244GB total RAM and 32 vCPUs, hosted in Citus Cloud (that’s our managed database as a service.)