citus Questions

add worker node and rebalance distributed shards problem with PostgreSQL + Citus

November 9, 2022
bluefish
2 Answers

The cluster had 1 coordinator and 6 worker nodes. (environment: PostgreSQL 15 + Citus 11.1) We want to add more worker nodes to it, so we executed SELECT * from citus_add_node('node-name', 5432); and SELECT rebalance_table_shards('table_name'); to got the messages as…

VIEW QUESTION

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

October 13, 2022
Gismat Husein
2 Answers

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 --network citus-network --name citus_coordinator -p 5500:5432 -e POSTGRES_PASSWORD=mypassword citusdata/citus:11.1 Then Database successfully…

VIEW QUESTION