Citus 10 is out! New features include columnar storage & Citus on a single node—plus we’ve open-sourced the shard rebalancer. Read the Citus 10 blog.

Skip navigation

Citus Use Cases

Multi-Tenant SaaS

SaaS apps grow fast, and need to scale while still providing a snappy user experience. Citus shards Postgres transparently at the data layer. And Citus makes it easy to add nodes & rebalance shards. So you can scale out as your app grows, without giving up Postgres.


Real-Time Analytics

Customer-facing dashboards need to provide sub-second responses to 1000s of concurrent users, while ingesting fresh data at the same time. Citus speeds up queries via parallelism, keeping more data in memory, higher I/O, & columnar compression.


Time Series

Time series workloads often need to grow beyond the resources of a single node. Capabilities such as the distributed query engine, columnar compression, parallel query, distributed DML… all combine to make Citus a good fit for time partitioned workloads.


Why Use Citus To Scale Out Postgres? One Word: Performance.

Citus distributes and parallelizes Postgres workloads—and is often used as a system of record for SaaS apps, and as a system of engagement for analytics dashboards and time series data. Sometimes, teams use Citus as their relational database for mixed transactional and analytics workloads, to avoid managing multiple different types of databases. Other teams use Citus for high throughput transactional apps. What most Citus users have in common: performance really matters to them—at scale.

SaaS teams choose Citus to shard Postgres, so they don’t have to re-architect their app to shard at the application layer. Developers building analytics dashboards tell us that distributed Postgres is a game changer. Citus is a fit for many types of data-intensive apps, including geospatial analytics (PostGIS), behavioral analytics—plus video, web, and operational analytics. And the new columnar storage feature in Citus 10 is a powerful addition to the ways Citus can help you scale your applications.

Why Scale Out Postgres?

Watch the Performance Demo from SIGMOD

YouTube video still: High performance PostgreSQL with Postgres & Hyperscale (Citus)

In this 15-min demo of Citus, see how Citus performs, using the HammerDB benchmark. Also featuring analytical query performance, and rollups.

These Segments Use Citus to Deliver Snappy Performance

Sales & Marketing icon
Sales & Marketing Automation
E-commerce icon
Web analytics icon
Analytics &
Network security icon
Information & Network Security
Ad networks icon
Finance icon
Jarred Nicholls pic

Citus makes things possible for us that would have been nightmarish in a NoSQL world. Moving to Citus has improved the reliability and performance of our database, and the fact that it’s not a black box and all the Citus metadata is open and hackable gives us a lot of flexibility. The Postgres expertise in the Citus team is also a big attraction and has made Citus a one-stop shop for us.

Jarred Nicholls
Former Chief Software Architect at IronNet Cybersecurity

Want to hear from our customers? Read our featured stories.

Recommended Next Steps