citus
citus copied to clipboard
citusdata
Distributed PostgreSQL as an extension
Hi all, for the last few days I tried some tests with Citus. I noticed that Citus does not support standard SQL functions that query distributed tables (even if they...
The following coredump generated with a Postgres server where Citus is installed. My initial reaction was that this core-dump doesn't have Citus functions involved, hence probably not relevant to Citus....
I have been warned against creating multiple databases in Citus on the Citus Slack channel, and Azure doesnt allow multiple databases being created on the same Citus instance; however there...
``` psql:/tmp/citus-catalog-v9-save20220719-6328-nhwg4h:6: ERROR: "foreign_table" is a foreign table DETAIL: Foreign tables cannot have TRUNCATE triggers. CONTEXT: SQL statement "create trigger truncate_trigger_45903 after truncate on foreign_tables_schema_mx.foreign_table execute procedure pg_catalog.citus_truncate_trigger()" PL/pgSQL function...
Consider the following statements: ```sql CREATE TABLE test(t timestamptz, user_id text); SELECT create_distributed_table('test', 'user_id'); PREPARE test_statement(text) AS SELECT * FROM test WHERE t >= $1::timestamptz; EXECUTE test_statement('2022-01-01'); ``` ## Expected...
pg14.4 + citus11.0 : the same machine centos7 0. ~/.pgpass is already configured 1. master 5432 create table t1(id int); set citus.shard_count to 2; select create_distributed_table('t1', 'id'); insert into t1...
To implement CDC for Citus, we would need to implement a logical decoder that filters out inserts that happen as a result of internal data moves (e.g. shard move, shard...
The installation instructions in CONTRIBUTING.md doesn't say anything about needing to install citus as the user that is running the PostgreSQL server, normally the "postgres" user on e.g. Ubuntu. It...
If another database has a maintenance daemon, it can only dropped from a database with the Citus extension. ``` $ psql template1 -c "CREATE DATABASE foo" $ psql foo -c...
While altering a distributed table with `alter_distributed_table`, Citus recreates materialized views depending on that table. Though, - Aliases - Storage parameters - Tablespace - WITH [NO] DATA options for materialized...
