citus
citus copied to clipboard
Distributed PostgreSQL as an extension
Context: removing nodes from cluster. by first draining them. nodes are marked as shouldhaveshards=false, i am logged in on one of the coordinators. After starting the drain i wanted to...
The documentation at https://docs.citusdata.com/en/stable/get_started/tutorial_multi_tenant.html has instructions to download the following sample data, but the links are no longer valid. They return a 301 Moved Permanently. - curl https://examples.citusdata.com/tutorial/companies.csv > companies.csv...
Hi, v18 beta1 is already out, so I started testing extensions against PostgreSQL 18. Citus 13.1.0 is failing with these errors (after updating configure for v18). Can you please take...
On an idle Citus cluster `citus_move_shard_placement()` to move shards from one worker to another (neither is the coordinator) peaks at 70 GB memory usage on the coordinator. In fact, we...
cherry-pick the following at once for citus_stat_counters, not just the first commit: 3d61c4dc71ef5f2377139662694746ace06216b2 d2e6cf1de0072ca012f27bce974dcfa95f16696b ea7aa6712dc8135b0aadd53943adcbbc4b63dd5b This only backports binary changes and the tests for testing early on dev machines. For...
```SQL create table local(id int); create table distributed(id int); select create_distributed_table('distributed','id'); set citus.local_table_join_policy TO 'prefer-distributed'; SELECT COUNT(*) FROM local JOIN distributed USING (id) JOIN (SELECT id, NULL, NULL FROM distributed)...
Add support for dynamically allocating new chunk groups when the configurable size limit is reached. This prevents memory allocation failures and improves scalability for large columnar data sets. - Add...
Is it possible to filter data using stripe_num directly from SQL ? Something like ```sql SELECT * FROM schema.table WHERE stripe_num = 10
Bumps [h2](https://github.com/python-hyper/h2) from 4.1.0 to 4.3.0. Changelog Sourced from h2's changelog. 4.3.0 (2025-08-23) API Changes (Backward Incompatible) Reject header names and values containing illegal characters, based on RFC 9113, section...
In the very peculiar case of including an oidvector type in a subquery that involves a distributed table: ```SQL -- dist_table is any distributed table SELECT * FROM( SELECT (SELECT...