Citus 11 is out! Now 100% open source. Read all about it in Marco’s release blog. 💥
Citus 11 is out! Now 100% open source. Read all about it in Marco’s release blog. 💥
Learn how to scale out Postgres with Citus, from a single node to a large distributed cluster. Citus is a Postgres extension, not a fork, and is 100% open source.
Citus distributes your Postgres database across multiple nodes and parallelizes your queries and transactions. The combination of parallelism, keeping more data in memory, and higher I/O bandwidth often leads to dramatic speed ups. In this chart, we show a benchmark SQL query running ~40x faster with an 8-node Citus cluster vs. a single Postgres node.
By introducing new Postgres table types—distributed tables and reference tables—Citus makes it possible to distribute your data and queries across multiple nodes. In addition to the new table types, the Citus architecture includes a distributed Postgres query planner and an adaptive query executor. Distributed transactions are also supported. As of Citus 10, you can shard on a single Citus node—and you use the Citus columnar feature to achieve compression ratios of 3x-10x or more. With the Citus 11 release, Citus is now 100% open source and you can query from any node.
Citus is an open source extension to Postgres (not a fork.) So when you use Citus, you’re still using Postgres under the covers, along with the Citus extension on top. To your application, running on a Citus distributed database is like running on top of a single Postgres node. And because Citus is an extension, it’s easy for us to keep Citus current with the latest Postgres releases—plus you get the performance benefits of horizontal scale, while still being able to leverage your familiar SQL toolset and your Postgres expertise.
Because Citus distributes your data, parallelizes your queries, keeps more data in memory, and gives you higher I/O bandwidth—Citus can meet the demanding performance requirements of mixed OLTP and OLAP workloads. So you can simplify your architecture by using a single database for your app’s transactional and analytical workloads, even for data-intensive applications. And with Citus 10, Citus gives you more capabilities: you can now use both columnar and row-based tables in your Citus distributed database.
Find out more about the Citus concepts, architecture, cluster management, APIs, use cases, & performance tuning.
See how Citus scales out Postgres and parallelizes your workloads via these YouTube videos. Tip: turn on captions.
Learn how to use Citus by using sample data in these short tutorials. For time series data, check out the use case guide.
You can download and install Citus open source packages for Docker, Ubuntu, Debian, Fedora, CentOS, and Red Hat via these simple steps.
You can stand up a Citus cluster in minutes with the Hyperscale (Citus) option in the Azure Database for PostgreSQL managed service.
Using sharding and replication, the Citus extension distributes your data and queries across multiple nodes in a cluster, to give your app parallelism as well as more memory, compute, and disk. Citus is available as an open source download and in the cloud as a managed service. The Hyperscale (Citus) option in Azure Database for PostgreSQL makes it easy to stand up a managed Citus cluster in minutes.
As of Citus 10, you can now shard Postgres on a single node, too. So you can adopt a distributed data model from the start to parallelize your queries—and be “scale-out ready.” Single-node Citus can also help to simplify your CI/CD pipelines.
Learn how Citus works in this talk about Citus table types, the PostgreSQL extension APIs, the Citus query planner, and performance benchmarks comparing multi-node Citus clusters to a single node.
Blog Post
Citus 11 for Postgres goes fully open source, with query from any node
Blog Post
Test drive the Citus 11.0 beta for Postgres
Release Notes
Official release notes for Citus 11.0 beta
Blog Post
Benchmarking performance of Citus and Postgres with HammerDB
Blog Post
What’s new in Citus 10.1
Blog Post
Citus 10: Columnar for Postgres, rebalancer, single-node, & more
New Feature
Citus 10 brings columnar compression to Postgres
Open Source News
Open sourcing the Citus shard rebalancer
New Feature
Sharding Postgres on a single Citus node
New Feature
Combining Postgres & Citus tables, feat. foreign keys
New Feature
JOINs between local & distributed Postgres tables
Blog Post
How to scale Postgres for time series data