Comparing Citus Database Options

Citus is an extension to Postgres that gives you all the greatness of Postgres at any scale—whether on a single node or on a large distributed cluster. Available as open source and as a managed service on Azure.

Looking for Citus on Azure? Now generally available, read all about it.
Citus Distributed Database Features

Citus Open Source Learn more Citus on Azure Hyperscale (Citus)

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

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. As of Citus 10, you can now shard Postgres on a single node, too.

yes yes

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

yes yes

Distributed transactions

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

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

With the new Citus columnar feature, you can compress regular Postgres tables and/or distributed tables to reduce disk footprint, reduce I/O bandwidth needs, and speed up analytics queries.

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

Probabilistic distincts (sketch algorithms)

yes yes

When adding nodes to a Citus cluster, the 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. The non-blocking shard rebalancer is now 100% open source, too.

yes yes

Granular access controls in Citus enable you to limit capabilities to certain types of users to control user access and reduce risk.

yes yes

Citus automatically manages user creation for you across the cluster, and enables fine-grained control over inter-node authentication using certificates or other methods.

yes yes

There is a High availability option in Hyperscale (Citus) in Azure Database for PostgreSQL. Turning on the HA option enables you to have standby replicas of every node, with automatic failover in your server group.

no yes

24x7 Support

no 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

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

no yes

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

no yes
Download Try now

Are You Ready to Distribute Postgres with Citus?