citusdata/citus

Distributed PostgreSQL as an extension

Stars: 12.8k
Forks: 794
Open beginner issues: 0
Indexed issues: 971
Avg merge: 2d 14h
Merged PRs (30d): 31

Dominant language: C
License: AGPL-3.0
Last GitHub push: Sep 14, 2026
Latest indexed: Sep 15, 2026
Contributing guide: Contributing guide
Code of conduct: Code of conduct
Beginner labels: good first issue

Open All

971 open issues indexed

Simpler multiple node install: Installation script that uses SSH Open

research usability

citusdata/citus#14 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Outer Join post-5.0 Improvements Open

technical debt

citusdata/citus#26 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Outer Join Improvements: Design unified join order planner Open

1-2 weeks priority:high technical debt

citusdata/citus#27 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Outer Join Improvements: Implement unified join order planner Open

technical debt

citusdata/citus#28 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Outer Join Improvements: Generate replacement for prunable outer join Open

technical debt

citusdata/citus#29 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Outer Join Improvements: Do not push down filters on outer join output in re-partition joins Open

technical debt

citusdata/citus#30 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Outer Join Improvements: Create bucket(s) for non-matching values Open

technical debt

citusdata/citus#31 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
PostgreSQL extension that can skip faulty lines in COPY Open

usability

citusdata/citus#35 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Simplify data migration from PostgreSQL to Citus Open

feature usability

citusdata/citus#37 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
PostgreSQL "better" materialized views Open

feature

citusdata/citus#43 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Kafka integration and communication Open

feature tech integration usability

citusdata/citus#44 · 5 comments · 0 reactions · 1 assignee · Indexed Sep 15, 2026
spark_fdw or provide native Spark integration Open

tech integration

citusdata/citus#47 · 6 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Repartitioned subselects over multiple tables Open

feature

citusdata/citus#48 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
MADlib integration Open

tech integration

citusdata/citus#51 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Cluster monitoring and management GUI Open

feature

citusdata/citus#53 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
One of the conditions for non-blocking PQconnectStart and PQconnectPoll is "The hostaddr and host parameters are used appropriately to ensure that name and reverse name queries are not made". We overlook this condition. Open

citusdata/citus#55 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Physical planner may assign fetch tasks to fetch data from nodes which are not in the membership list. Open

citusdata/citus#59 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
If the user runs a query with a filter clause like 'timestamp > now() - 1 day', we don't apply partition pruning. Open

citusdata/citus#64 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
When we try to do large table joins on varchar columns, we get an error of the form: ERROR: cannot perform local joins that involve expressions DETAIL: local joins can be performed between columns only Open

bug

citusdata/citus#76 · 6 comments · 0 reactions · 1 assignee · Indexed Sep 15, 2026
We can not partition over column types like json which does not support aggregate functions. We should add a custom error messages for these cases. Open

citusdata/citus#83 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Based on comments in include/catalog/genbki.h and the way most PostgreSQL catalogs are defined, variable length catalog fields should be in the end of the definition and hidden. We need to integrate this rule into our distributed system catalogs Open

citusdata/citus#84 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Support Explain Queries with re-partition jobs Open

usability

citusdata/citus#91 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
In worker_partition_protocol.c, we have a range repartition and a hash repartition function. These functions are asymetric in terms of how they bucket Null values. Making them symmetric is important in the context of Left and Right outer joins. Open

citusdata/citus#104 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
We ran code coverage with our regression tests. We found out that MasterAggregateMutator and WorkerAggregateWorker on Var input didn't get called at all. If we don't need this code path, we should remove it Open

citusdata/citus#107 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
We may want to replace GetFunctionInfo() with PostgreSQL function lookup_type_cache(). lookup_type_cache() and GetFunctionInfo() uses same functions and parameters, so they resolve to same FmgrInfo Open

citusdata/citus#109 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Subquery Stage 3 - replace debug printing functions Open

citusdata/citus#114 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Subqueries Stage 3 - Finalize design for MultiExtendedOp with order by and limit Open

citusdata/citus#115 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add MultiUnion, MultiSemiJoin, and Lateral node data structures, update Commutativity, Distributiveness and Associativity rules Open

citusdata/citus#116 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Distributed EXPLAIN: Phase 3 - Complex queries Open

citusdata/citus#121 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Any queries do not work on tables which are distributed on columns that does not have any default op class (ie:json, point). The error message is: "cache lookup failed for opclass 0" Open

citusdata/citus#134 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Partition and join pruning do not work on constituent fields of composite types (even if all constituents are supplied and ANDed). Open

citusdata/citus#135 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Handle joins between columns with different types. This may currently result in a Cartesian Product operator. Open

citusdata/citus#138 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Approximate count(distinct) queries use hll as their intermediate data type. We have a mismatch between hll target entry and sort clause's sortop oid, so we can't push an order by on the hll data type to worker nodes. Open

citusdata/citus#140 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
We currently don't push down SELECT clauses containing OR's. An optimization would be to allow pushdown of OR-select clauses if they contain columns only from a single table. Open

citusdata/citus#141 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Pull in partition related functions into their own files. Such as PartitionColumn in multi_join_order.c and PartitionMethod in multi_logical_optimizer.c. Open

citusdata/citus#150 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Encapsulate all shard-related statistics, metadata and permission information into system catalogs tables. Also define migration policy for these tables in a distributed setting. Open

citusdata/citus#169 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Determine if we need to add checksums for intermediate query or partition files. Hadoop uses IFileInputStream.java to add 4-byte checksums for intermediate map files Open

citusdata/citus#174 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add the following checks to a table creation statement to verify: (i) this node runs as the master node, (ii) table does not make use of the inhertiance mechanism, (iii) table does not own columns that are sequences, and (iv) table does not have collated columns. Open

citusdata/citus#181 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
We need to extend partitioning logic and make it similar to indexing logic. We should either allow one expression (for hash partitioning), or a list of table column values and object ids (for append and range partitioning) Open

citusdata/citus#194 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
The task assignment algorithm considers the current value of shard_replication_factor rather than the value that was used to stage the data. This leads to unexpected side effects Open

citusdata/citus#198 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Use consistent terminology in our error messages Open

priority:high

citusdata/citus#207 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Create databases during shard creation Open

feature research

citusdata/citus#210 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Prohibit non-IMMUTABLE functions in multi-shard SELECT queries Open

citusdata/citus#224 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add group by on composite type support. Open

citusdata/citus#262 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
OUTER JOIN: properly support single re-partitioning Open

citusdata/citus#263 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 15, 2026
Research PL/pgSQL formatting tools Open

citusdata/citus#268 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Produce Citus Data PL/pgSQL style guide Open

citusdata/citus#269 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Audit correctness of places CitusDB constructs SQL from strings (quote_literal_cstr, etc.) Open

citusdata/citus#270 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add a generic ListMember function and rename ListMember to WorkerListMember. Open

citusdata/citus#272 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Consider addition of a foreach_with_index() macro. Open

citusdata/citus#273 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026

A short digest of beginner-friendly GitHub issues.