Skip to main content

Questions tagged [citus]

Citus is an open source extension to Postgres, transforming it into a distributed database.

Filter by
Sorted by
Tagged with
0 votes
0 answers
26 views

Postgresql Logical Replication from citus distributed table to another citus distributed table

I followed this guide (https://docs.citusdata.com/en/stable/develop/integrations.html) to implement logical replication of the "items" table between two postgres db. On DB1 the "items&...
Babylon Big Data's user avatar
0 votes
1 answer
29 views

Citus: Parallel worker not launching

We are performing Citus benchmarking and came across a situation where the planner makes the parallel execution plan but during the execution no parallel workers are launched. The cluster has 3 worker ...
goodfella's user avatar
  • 168
0 votes
0 answers
27 views

citus high availability setup with patroni

We want to setup patroni HA setup with 3 coordinator, 2 worker node 1 & 2 worker node 2. I am getting system id mismatch when i start 2nd coordinator. First one is running fine, only facing issue ...
jack's user avatar
  • 101
0 votes
1 answer
39 views

INSERT my_table (fields,...) value (value_1,...), (value_2, ...)... is slow in citus

Environment: host: resources:32 cores, 64GB RAM, Docker 24.07 OS: CentOS 7 disk: 10 separate disk partitions The 10 separate disk partitions are as below df -h filesystem capacity used ...
wureka's user avatar
  • 159
0 votes
1 answer
91 views

Setup Citus extension in a ssh environment

I tried to do CREATE EXTENSION citus;. However, I was given the following error: ERROR: Citus can only be loaded via shared_preload_libraries HINT: Add citus to shared_preload_libraries ...
Disdainty's user avatar
6 votes
0 answers
293 views

Right way to set up a secondary citus worker

I am experimenting with the postgres-addon citus. So far I have setup a cluster with one coordinator and three worker nodes. Now I want to setup a secondary for one of the worker nodes. So far I have ...
Nils's user avatar
  • 149
1 vote
2 answers
528 views

Postgresql doesn't working with Citus and pg_stat_statements at the same time

So, I built the PostgreSQL with citus extension in docker. I use the official documentation in citus, then I run this command in the terminal. docker run -d -v /root/volumes/citus-data:/data --...
Gismat Gusein's user avatar
2 votes
1 answer
376 views

Can the citus data coordiator and worker node be on the same machine?

Reading citus data's tutorial, I was wondering if in a small cluster, I can have the coordinator and one of the workers installed on the same machine? I am testing this on a small scale cluster with ...
tinlyx's user avatar
  • 3,620
0 votes
0 answers
80 views

Why does postgres/citus use the index when querying the table, but not trough the view?

I have a Citus 9.5 database (postgres 11) on Azure and executing a complicated query with CTEs. The schema has a simple view from another schema as: create view my_schema.table1 as select * from ...
Brendan Hill's user avatar
0 votes
0 answers
1k views

AWS DMS Task failed with error: Error executing source loop; Stream component failed at subtask 0

I want to migrate my PostgresDB hosted in Citus cloud service to AWS RDS Aurora Postgres. I am using AWS DMS service. Have created task but getting following errors: Last failure message Last Error ...
Ashish Karpe's user avatar
1 vote
1 answer
1k views

Postgres Citus error "complex joins are only supported when all distributed tables are joined on their distribution columns with equal operator"

I have two tables defined as distributed in Citus based on the same field: select create_distributed_table('gedi','clould_metadata_id'); select create_distributed_table('cloud_metadata','...
Mauro Assis's user avatar
1 vote
2 answers
936 views

Replicating PostgreSQL data into Citus/Greenplum?

I need to integrate data from 3 different PostgreSQL databases (OLTP application backends) in a data warehouse. For the data warehouse itself I consider using Citus or Greenplum. There is a ...
Denis Arharov's user avatar
0 votes
1 answer
555 views

Slow insert in Postgresql when sharding using declarative partitioning and postgres_fdw?

We have been trying to partition a Postgres database on google cloud using the built-in Postgres declarative partitioning and postgres_fdw as explained here. We are running commands as follow: Shard ...
hardik24's user avatar
0 votes
1 answer
3k views

PostgreSQL + Citus - multi master - replication of data

I have a question, I have found a Citus extension which is recommended for a replication of data between multi-master nodes (I was using Galera Cluster prior to PostgreSQL). However I cannot find any ...
Mike's user avatar
  • 111
5 votes
2 answers
621 views

PostgreSQL Citus Extension Temp Table

Is it possible with citus extension in PostgreSQL to create temp table that is copied to each worker node (like reference table)? When I run SQL like this: DROP TABLE IF EXISTS mypoint; CREATE TEMP ...
Slobodan Savkovic's user avatar
1 vote
2 answers
6k views

PostgreSQL surrogate keys: use sequence/bigint or OID?

I'm looking at a need for surrogate keys in tables I'm designing on a PostgreSQL-derived DBMS (Citus). Would OIDs suffice? Is there a downside to using them instead of creating a bigint field and a ...
Andrew Wolfe's user avatar