#6868th of 204 in Backends, databases and hosting
citus
PostgreSQL extension that shards tables across nodes for distributed queries
- Stars
- 12.9k
- License
- AGPL-3.0
- Last commit
- Nov 2026
- Last release
- Oct 2026
- Language
- C
12,385 on 25 Apr 202612,866 on 14 Nov 2026
From GitHub's daily star counts.
Checked on GitHub.
Overview
Citus is a C-based PostgreSQL extension that adds distributed tables, replicated reference tables, a distributed query engine and columnar storage. It runs on a single node or a coordinator plus worker cluster, with shard rebalancing when nodes are added. Aimed at multi-tenant, real-time analytics and time-series workloads that outgrow one Postgres server.
Who it is for: Teams scaling PostgreSQL beyond one node for multi-tenant or analytics workloads
Strengths
- Runs inside regular PostgreSQL, so existing SQL, extensions and tools keep working
- Co-located distributed tables allow distributed joins and foreign keys on the distribution column
- create_distributed_table_concurrently converts live tables without blocking reads or writes
- Schema-based sharding for multi-tenant and microservice apps without query changes
Weaknesses
- Columnar tables do not support update, delete or foreign keys
- Licensed AGPL-3.0, which may constrain some commercial use
- Multi-node setup needs manual coordinator and worker configuration and shard rebalancing
- Requires choosing a distribution column up front for good query routing
What it needs
- no GPU
- Needs PostgreSQL 18
What changed
From the release notes. No flag means the note does not say so, not that the upgrade is safe.
Known problems
Open now, reported in the last 90 days
Reported, then fixed by a linked change
- "Create extension if not exists" fails on Citus workers ↗ (opens in a new tab)2 reactions · closed 10 Feb 2026Fixed by Fix CREATE EXTENSION IF NOT EXISTS for non-owner users ↗ (opens in a new tab)
- Role propagation error due to interdependent roles while adding new nodes ↗ (opens in a new tab)1 reactions · closed 15 May 2026Fixed by Backport #8466 to release-13.2: Fix role propagation error due to missing grantor dependencies ↗ (opens in a new tab)
- master_add_node fails to sync metadata if there is a DOMAIN defined within a schema other than public. ↗ (opens in a new tab)1 reactions · closed 15 Jan 2026Fixed by Fix metadata sync failure with domain types in non-public schemas ↗ (opens in a new tab)
- unable to add node when distribution columns have different collation types ↗ (opens in a new tab)0 reactions · closed 18 Jan 2026Fixed by Disallow colocating tables when collations don't match ↗ (opens in a new tab)
- INSERT ... SELECT ... between schema based sharding tables incorrectly without erroring out ↗ (opens in a new tab)0 reactions · closed 16 Jan 2026Fixed by Fix empty task in worker subquery with reference or schema sharded table ↗ (opens in a new tab)
Titles are the reporters' own words, taken from the project's GitHub issues and ranked by reactions. We have not tried to reproduce any of them.
Also in Backends, databases and hosting
See all 204| Rank | Project | Score |
|---|---|---|
| 1 | bunJavaScript and TypeScript runtime with bundler, test runner and package manager | 94 out of 100 |
| 2 | coolifySelf-hosted Heroku and Vercel alternative that deploys apps and databases over SSH | 93 out of 100 |
| 3 | strapiHeadless CMS that generates REST and GraphQL APIs from content models | 92 out of 100 |
| #4 | traefikHTTP reverse proxy and load balancer that auto-discovers routes from orchestrators | 92 out of 100 |
| #5 | appwriteBackend with auth, databases, storage, functions and an MCP server for agents | 92 out of 100 |