How to Get Citus

Citus Open Source icon

Citus Open Source

With Citus, you can scale Postgres with superpowers like distributed tables, distributed SQL engine, columnar, & more.

Azure cloud icon

Citus on Azure

You can also spin up a Citus cluster in the cloud on Azure with Azure Cosmos DB for PostgreSQL.

Why Citus?

  • Distributed Scale

    Scale Postgres by distributing data & queries. You can start with a single Citus node, and simply add nodes & rebalance shards in order to grow.

  • Simplified Architecture

    Reduce your infrastructure headaches by using a single database for both your transactional and analytical workloads.

  • Parallelized Performance

    Speed up queries by 20x to 300x (or more) through parallelism, keeping more data in memory, higher I/O bandwidth, and columnar compression.

  • Citus elicorn icon
    Open Source

    Download and use Citus open source for free. You can manage Citus yourself, embrace open source, and help us improve Citus via GitHub.

  • Postgres elephant outline icon
    Power of Postgres

    Citus is an extension (not a fork) to the latest Postgres versions, so you can use your familiar SQL toolset & leverage your Postgres expertise.

  • managed database service cloud icon
    Managed Database Service

    Focus on your application and forget about your database. Run your app on Citus in the cloud with Azure Cosmos DB for PostgreSQL.

2 Ways to Shard Postgres with Citus

Row-based sharding

Row-based sharding is the traditional way Citus does sharding and is useful for all use cases, especially real-time analytics, time series, & IOT.

row-based sharding worker node 1 row-based sharding worker node 2

Schema-based sharding

First introduced in Citus 12, schema-based sharding is easier to use since you don’t need a distribution key. Good for multi-tenant SaaS & microservices.

schema-based sharding worker node 1 schema-based sharding worker node 2

Why Scale Out Postgres? Performance.

Side-By-Side Performance Comparison

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

Watch this demo to see how Citus gives this application ~20X faster transactions and 300X – 150,000X faster analytics queries.

What’s New in Citus?

Citus 12.1 flag

Citus 12.1

Citus 12.1 is out & includes support for Postgres 16! With logical replication enhancements and outer join performance improvements.

Read 12.1 post  |  12.1 updates


POSETTE: An Event for Postgres 2024 is a wrap, but you can still watch all 42 talks from the 4 livestreams! Be inspired.

Watch the sessions

newspaper in front of a cloud icon

New Azure Home

We have a new home on Azure! You can now find the Citus managed database service in Azure Cosmos DB for PostgreSQL.

Read the docs  |  Try for free

Citus 12.1 is out! Read all about it in the Citus 12.1 blog post!

Capabilities of Distributed Postgres With Citus

Is Citus Right For You?

Not every application benefits from distributing Postgres, parallelizing queries, compressing tables via columnar, and the ability to scale from a single node to a distributed database cluster. But many do. Some popular use cases for the Citus database: multi-tenant SaaS apps, real-time analytics, time series, & microservices.

Citus workloads Venn diagram
When Not to Use Citus—because not all workloads need Postgres at any scale
  • If you do not expect your app to grow & Postgres on a single node supports your app just fine.
  • If you only need offline analytics & do not need real-time ingest nor real-time queries.
  • If your app does not need to support a large number of concurrent users.
Postgres icon

Scale Out Your Database Without Giving Up Postgres

  • The Citus database is a PostgreSQL extension and not a fork, in sync with all the latest releases.
  • Leverage your PostgreSQL expertise and all your familiar tools in the Postgres ecosystem.
  • Take advantage of all the innovations in Postgres—including rich data types and extensions like JSONB, PostGIS, HyperLogLog, pg_stat_statements, and full text search.
  • Scale out your database without giving up SQL. You don’t get joins from NoSQL databases. And application-level sharding solutions will not give you joins when you need them.
  • Citus makes it simple to shard Postgres. We’ve done the distributed systems engineering work to scale out Postgres for you. So you can use Postgres at any scale—from a single node to a large distributed cluster.