Questions tagged [citus]
Citus is an open source extension to Postgres, transforming it into a distributed database.
12
questions
0
votes
1
answer
35
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 ...
6
votes
0
answers
209
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 ...
- 149
1
vote
2
answers
398
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 --...
2
votes
1
answer
299
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 ...
- 3,425
0
votes
0
answers
65
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 ...
- 281
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 ...
- 101
1
vote
1
answer
874
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','...
- 111
1
vote
2
answers
794
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 ...
- 101
0
votes
1
answer
498
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 ...
- 93
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 ...
- 11
5
votes
2
answers
551
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 ...
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 ...
- 584