Citus Con: An Event for Postgres is a free & virtual event happening Apr 12-13 in 2022—and the CFP is now open! Learn more in the Speaker FAQ for Citus Con.

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.

How Citus Distributes Postgres

Watch Marco’s latest talk, inspired by SIGMOD

Video thumbnail: screen with Citus performance benchmarks

Learn how Citus works in this talk about Citus table types, the PostgreSQL extension APIs, the Citus query planner, and performance benchmarks comparing a multi-node Citus cluster to a single node.

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