Comparing Citus Database Options

Citus is an extension to Postgres that distributes your data & your queries across multiple nodes. Available as open source, as on-prem enterprise software, and in the cloud, built into Azure Database for PostgreSQL.

Looking for Citus on Azure? Now generally available, read all about it.
Citus Distributed Database Features: Citus Community Open Source Citus on Azure Hyperscale (Citus) Citus Enterprise Enterprise Software

Citus is Postgres, which means we offer relational database features like ACID transactions, joins, foreign key constraints, and SQL coverage.

yes yes yes

Citus is an extension to Postgres that enables you to scale out Postgres across multiple nodes, giving your Postgres database a much larger memory, compute, and disk footprint than on a single-node. And increasing performance in a big way. At Citus, we like to say that we make sharding simple.

yes yes yes

Distributed query planner and executor that parallelizes queries across shards, enabling massive parallelism and efficient resource utilization.

yes yes yes

Citus is not a fork, rather we use PostgreSQL’s extension APIs to scale out. We give you trusted, familiar Postgres.

yes yes yes

PostgreSQL and Citus support 40+ data types, including semi-structured data types and JSONB. Popular Postgres extensions frequently used with Citus include HyperLogLog (HLL), PostGIS, TopN, hstore, pg stat statements, dblink, plpgsql, uuid ossp, ltree, & more.

yes yes yes

Citus is available as open source (Citus Community), as on-prem enterprise software (Citus Enterprise), and in the cloud on Microsoft Azure, built into Azure Database for PostgreSQL.

yes yes yes

Works with Ruby, Python, Java, Node.js, Javascript, Go, C++. And to make it easy to migrate your multi-tenant Rails and Django apps to Citus, we’ve created PostgreSQL libraries: activerecord-multi-tenant gem on Rails, and django-multitenant library for Django.

yes yes yes

Distributed transactions

yes yes yes

Probabilistic distincts (sketch algorithms)

yes yes yes

Fine-grained access controls

no yes yes

Hyperscale (Citus) on Azure Database for PostgreSQL includes fully automated HA; Citus Enterprise includes support for automated monitoring and management of failover for a Citus database cluster.

no yes yes

Multi-tenant SaaS applications sometimes need to isolate the shards for a large customer to ensure that the large customer gets the resources they need and doesn’t negatively impact performance for everyone else. Hence: tenant isolation.

no yes yes

24x7 Support

no yes yes

When adding nodes to a Citus cluster, the zero-downtime shard rebalancer enables you to redistribute shards across old and new nodes to better balance the data distribution and the performance of your Citus database.

no yes yes

In Hyperscale (Citus) on Azure Database for PostgreSQL, you can provision a cluster (called a ‘server group’) in just a few clicks; adding more nodes & increasing memory, compute, and disk is simple, too.

no yes no

Citus is available in the cloud, built into Azure Database for PostgreSQL, a fully-managed database as a service. Available in a growing list of Azure regions, Hyperscale (Citus) on Azure Database for PostgreSQL includes automated backups, point in time recovery, automated health checks, & automated monitoring.

no yes no

Hyperscale (Citus) on Azure Database for PostgreSQL includes 2FA, encryption at rest and in flight, IP whitelisting, and of course continual review of security vulnerabilities.

no yes no
Download Get started Contact us

Are You Ready to Learn More about Citus on Azure?