Citus Use Cases

Citus is worry-free Postgres that scales out. Made for SaaS businesses, Citus powers both multi-tenant applications and real-time analytics.

Citus delivers value in a variety of use cases across multiple industries. These range from customer facing real-time dashboards in ad-tech companies or SaaS analytics providers to behavioral analytics in mobile / web analytics platforms to real-time geospatial analytics and operational analytics in retailers or telco operators. Citus makes all of these use cases available by providing:

  • Seamless horizontal scaling by sharding your data across multiple Postgres hosts
  • Intelligently parallelizing your queries to distribute workloads
  • Multiple executor types to optimize for your workload
  • Integrating with native PostgreSQL tools across the PostgreSQL ecosystem.

Scaling multi-tenant SaaS applications

Citus makes it easy for you to continue scaling your data for a multi-tenant application by seamlessly sharding your data. Because Citus extends Postgres you do not have to pull large tables out or entirely re-architect to continue scaling when you start to outgrow a single node which can happen as early as 100 GB.

With Citus your entire dataset can easily be split up across multiple physical machines allowing you to scale memory and compute, and your tenants still reside on the same node. This provides performant joins and the full breadth of SQL when interacting with a single tenant as most B2B applications do.

  • Scale to millions of tenants
  • Full transaction support when interacting with a single tenant
  • Full SQL coverage when querying a single tenant

Real-time Analytics Dashboards

Citus combines fast reads and writes with powerful analytics in one database which allows you to implement a cost effective architecture to power real-time dashboards. You can provide insights which include both your real-time data and your historical data.

Citus has a high data ingestion rate so you can ingest terabytes of data every day, in real-time as your data is generated. Citus uses parallel query processing to provide very fast query responses, which enables real-time insights on real-time data.

Read More
  • Optimized for event/time-series data
  • Sub-second queries with parallelism
  • Real-time data ingest
  • High concurrency

Behavioral Analytics

Citus enables interactive cohort and funnel analytics on real-time event data at scale. It can serve instant responses to concurrent queries with on-the-fly segmentation and funnel step definitions.

It simplifies and speeds up behavioral analytics through use of advanced analytics functions built on PostgreSQL’s powerful expressiveness. Citus also allows you to update your data in real-time so your end users always see fresh insights into your current data.

  • Optimized for clickstream, users, events data
  • Advanced funnel, cohort and session analytics libraries
  • Real-time data ingest
Read More

Operational Analytics

Citus enables you to scale out real-time operational analytics with the power of a relational database.

You can combine powerful analytics with fast inserts/updates for reduced complexity and cost while utilizing powerful and familiar PostgreSQL expressiveness and tools.

Read More
  • Hybrid operational and analytics workloads
  • Horizontal scalability on commodity hardware
  • Standard PostgreSQL drivers and tools
  • Offered real time insight to B2B sales team on 160TB of data

Fast geospatial analytics

Citus allows you to utilize the power of hundreds or even thousands of CPU cores to analyze your geospatial data with human real-time responsiveness.

As your data grows, you can horizontally scale out on commodity servers and achieve analytics performance that is orders of magnitude higher than what is possible with single threaded geospatial databases today.

Read More
  • Optimized for geofencing
  • Support for PostGIS
  • Parallelized query processing