Stack Overflow
Stack Overflow

Questions tagged [citus]

Citus is a distributed database that lets you run SQL queries over very large data sets.

Citus is a distributed database that lets you run SQL queries over very large data sets. https://github.com/citusdata/citus

131 questions
1
vote
1 answer

Query against worker nodes omitting the coordinator in Citus

Existing documentation for Citus11 explicitly points out that external clients should interact with the Citus cluster through the coordinator node, which is supposed to route request among workers. However, if I create a cluster using the…
Daniil Grudzinskiy
  • 420
  • 3
  • 15
1
vote
1 answer

Update PostgreSQL 14 to 15 with active citus extension

I am trying to use the official way to upgrade from PG 14 to 15 with Citus. If I would follow these instructions, I would have upgraded PG, but not citus, since nowhere the citus111_15 rpm is being installed (CentOS 7)? I am a little bit confused…
Nils
  • 121
  • 7
1
vote
1 answer

How to promote metadatasynced worker to coordinator in Citus, if coordinator completely lost

I have a citus cluster with 1 coordinator and 3 workers. Recently, the server which hosted coordinator is completely down which cannot be recovered. Now the cluster only does Query and Some DML, but not DDL, which can only be executed on…
Archon
  • 1,385
  • 1
  • 15
  • 30
1
vote
1 answer

Sharding with replication

Sharding with replication]1 I have a multi tenant database with 3 tables(store,products,purchases) in 5 server nodes .Suppose I've 3 stores in my store table and I am going to shard it with storeId . I need all data for all shards(1,2,3) available…
Behdad
  • 184
  • 3
  • 12
1
vote
0 answers

Could not access file “citus”:no such file or directory;

when i start postgres-14, then tell me "Could not access file “citus”:no such file or directory;" i have insetlled citus. but i still don't start postgres-14.can you help me?
scott
  • 11
  • 1
1
vote
1 answer

Can we use Citus with Gorm?

We are trying to do distributed DB using PostgreSQL. We came across Citus (https://github.com/citusdata/citus) but we are using GORM as ORM for our backend. Is it possible to combine both??
Mekatoo
  • 39
  • 1
  • 6
1
vote
1 answer

Greenplum vs Citus for Data Warehouse

I'm trying to evaluate Citus and Greenplum in terms of using them as a Data Warehouse. The general idea is that data from multiple OLTP systems will be integrated in real time via Kafka Connect in a central warehouse for analytical queries. How does…
Denis Arharov
  • 91
  • 1
  • 10
1
vote
1 answer

What are settings to lookout for with Citus PostgresQL

We are looking into using CitusDB. After reading all the documentation we are not clear on some fundamentals. Hoping somebody can give some directions. In Citus you specify a shard_count and a shard_max_size, these settings are set on the…
heldopslippers
  • 828
  • 2
  • 9
  • 20
1
vote
0 answers

Slow concurrent postgres inserts into separate tables with indexes

I'm running into an issue where I have 24 insert queries which all insert into different tables (shards), and they run slowly when the inserts are performed concurrently. When I run them sequentially, they're pretty fast. Strange thing, these all…
Mathias Versichele
  • 337
  • 1
  • 11
1
vote
1 answer

PostgreSQL - should I use EXCLUSIVE LOCK mode Logical Replication in Postgresql 11?

I am using the PostgreSQL 11 with Citus Extension community edition. I have 2 tables, each with 32 shards distributed among 2 nodes (Postgres servers with Citus Extension). Each shard from Table A has a group of Colocated shards (data dependent on…
Manish Gupta
  • 4,438
  • 18
  • 57
  • 104
1
vote
1 answer

Citus co-location with jsonb relation

I'm trying to co-locate tables in a cluster using citus, but the relationship is mentioned in the tables in a json scheme, as in the example below: TABLE person( id uuid PRIMARY KEY, ... ); TABLE event( id uuid PRIMARY KEY, resource…
Paulo Reis
  • 25
  • 3
1
vote
2 answers

Is it possible to install Citus extension on official Postgres binary?

I don't want to use the Citus provided binary for PostgreSQL server. Since Citus it is an extension, I believe it should play well with the official Postgres server binary.
Dojo
  • 5,374
  • 4
  • 49
  • 79
1
vote
1 answer

I get error when create distributed table on citus (postgres)

I created a table on Citus: CREATE TABLE myschema.mytable Then I created function that gets data from table myschema.mytable: CREATE FUNCTION myschema.myfunction(id INT) RETURNS INT AS $$ DECLARE approved_count INT; BEGIN SELECT COUNT(id) INTO…
Alex
  • 601
  • 7
  • 11
1
vote
1 answer

Citus vs regular postgres performance

I was testing citus postgres vs postgres 11 and I tried comparing single postgres 11 t2.medium instance on amazon with: t2.medium instance with installed citus postgres 11 (2 working nodes and 1 coordinator on 1 instance) 2 worker nodes and 1…
Jonhtra
  • 897
  • 2
  • 12
  • 18
1
vote
1 answer

Kubernetes Citus setup with individual hostname/ip

I am in the process of learning Kubernetes with a view to setting up a simple cluster with Citus DB and I'm having a little trouble with getting things going, so would be grateful for any help. I have a docker image containing my base debian image…
bcpvis
  • 13
  • 2
1 2
3
…
8 9