Owner

citusdata

20 indexed repositories · View on GitHub

citus
Distributed PostgreSQL as an extension

C · 12767 stars
pg_cron
Run periodic jobs in PostgreSQL

C · 3887 stars
cstore_fdw
Columnar storage extension for Postgres built as a foreign data wrapper. Check out https://github.com/citusdata/citus for a modernized co...

C · 1782 stars
postgresql-hll
PostgreSQL extension adding HyperLogLog data structures as a native data type

C · 1230 stars
pg_shard
ATTENTION: pg_shard is superseded by Citus, its more powerful replacement

C · 1060 stars
django-multitenant
Python/Django support for distributed multi-tenant databases like Postgres+Citus

Python · 823 stars
activerecord-multi-tenant
Rails/ActiveRecord support for distributed multi-tenant databases like Postgres+Citus

Ruby · 759 stars
postgres_vectorization_test
Vectorized executor to speed up PostgreSQL

C · 335 stars
docker
:ship: Docker images and configuration for Citus

Dockerfile · 273 stars
postgresql-topn
TopN is an open source PostgreSQL extension that returns the top values in a database according to some criteria

C · 249 stars
citus-example-ad-analytics
Reference App for Ad Analytics, using Ruby on Rails.

CSS · 79 stars
citus_docs
Documentation for Citus. Distributed PostgreSQL as an extension.

CSS · 58 stars
citus-benchmark
Tools for running benchmarks against Citus

Python · 44 stars
membership-manager
:ship: Docker image for managing Citus membership via docker-py

Python · 22 stars
packaging
Packaging scripts for Citus

Dockerfile · 19 stars
test-automation
Tools for making our tests easier to run

C · 15 stars
pgconfus-tutorial-multi-tenant
Files for the tutorial on Citus & Multi-Tenant Models @ PGConf US 2017

Ruby · 9 stars
pg_intpair

C · 7 stars
the-process
Trust it.

Dockerfile · 6 stars
realtime-dashboards-resources
Some useful scripts

PLpgSQL · 5 stars

Open All

1619 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

citusdata

Get new issues in your inbox