citus
citus copied to clipboard
citusdata
Distributed PostgreSQL as an extension
**Issue by [jberkus](https://github.com/jberkus)** _Thursday Dec 04, 2014 at 22:34 GMT_ _Originally opened as https://github.com/citusdata/pg_shard/issues/3_ --- Currently the user has to manually create databases on each worker to match the master....
# Description Currently, there are a lot of issues with tables whose owner is a `ROLE` (a user with `NOLOGIN` set, to be precise). Among them 1. Inability to `create_distibuted_table`,...
When I Create table for structure, I got an Error Message, my SQL code is as follow: ``` CREATE TABLE struct( id int not null, binary_molcontent bytea, primary key (id)...
```sql create table usertable (id bigserial primary key, value text not null); -- CREATE TABLE update usertable set value = 'row' || id; -- UPDATE 0 select create_distributed_table('usertable', 'id', shard_count...
In case of citus downgrade and further upgrade citus crash with core dump. The reason is that citus hardcoded number of columns in pg_dist_partition table, but in case of downgrade...
We execute the subplans normally, and again as part of EXPLAIN ANALYZE: ``` CREATE TABLE test (x int primary key, y int); SELECT create_distributed_table('test','x'); EXPLAIN ANALYZE WITH a AS (INSERT...
We have bit shift operation without control of shift length in citus_stat_tenants.c. Shift operators where the amount shifted is greater or equal to the promoted bit-width of the left hand...
**How to **reproduce**** Database version: PostgreSQL 16.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 Citus version: Citus 12.1.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 **Problem Description:** In a Patroni-based...
I've encountered an issue with pg_partman when running maintenance on a distributed table. The maintenance process fails with the following error message: ``` SQL Error [P0001]: ERROR: cannot modify table...
I have setup citus(v12.1.15) cluster using postgreSQL16.4 with one coordinator and tow worker in 3 physical machine,with node run in docker. coordinator has 27TB size,worker1 has 22TB,worker2 has 6TB，while excute...
