citusdata/citus
FreeDistributed PostgreSQL as an extension
FreeFree tier
About citusdata/citus
Citus is a PostgreSQL extension that transforms Postgres into a distributed database, enabling high performance at any scale. It provides distributed tables sharded across a cluster, reference tables replicated to all nodes, a distributed query engine that parallelizes SELECT, DML, and other operations, columnar storage for compression and fast scans, and the ability to query from any node. Citus is ideal for multi-tenant applications, real-time analytics, and time series or IoT data. It works seamlessly with existing PostgreSQL tools and extensions, and you can scale out by adding worker nodes and rebalancing shards.
Key Features
Distributed tables sharded across a PostgreSQL cluster to combine CPU, memory, storage, and I/O
Reference tables replicated to all nodes for joins and foreign keys
Distributed query engine that parallelizes SELECT, DML, and other operations
Columnar storage for data compression and fast scan performance
Query from any node to utilize full cluster capacity for distributed queries
Seamless integration with existing PostgreSQL tools and extensions
Pros & Cons
Pros
- Horizontally scales PostgreSQL beyond a single node
- Supports high transaction throughput and fast analytical queries
- Columnar compression reduces storage and speeds up scans
- 100% open source and free to use
- Works with any PostgreSQL tool or extension
Best For
Scale-out multi-tenant applications with high transaction throughputReal-time analytics on large datasetsTime series and IoT data processing for real-time analyticsWhen a single PostgreSQL node encounters performance or scalability limits