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
0
votes
1 answer

Citus "... is a metadata node, but is out of sync HINT: If the node is up, wait until metadata gets synced to it and try again."

I've got a Citus (v10.1) sharded PostgreSQL (v13) cluster with 4 nodes. Master node address is 10.0.0.2 and the rest are up to .5 When trying to manage my sharded table, I've got this error: ERROR: 10.0.0.5:5432 is a metadata node, but is out of…
Mr.TK
  • 1,743
  • 2
  • 17
  • 22
0
votes
1 answer

citus can I use join if I use citus?

citus can I use join if I use citus ? And yes are they performant…
localdata01
  • 587
  • 7
  • 17
0
votes
1 answer

How to get aggregate row count for sharded tables in citus postgres

Requirement is to get sum of reltuples for all distributed tables in Citus Postgres database with a certain format which is explained below. When i run the below command, the query propagates to workers and depending on the shard counts on each…
MrKickass
  • 93
  • 1
  • 13
0
votes
1 answer

Citus: How can I add self referencing table in distributed tables list

I'm trying to run create_distributed_table for tables which i need to shard and almost all of the tables have self relation ( parent child ) but when I run SELECT create_distributed_table('table-name','id'); it throws error cannot create foreign key…
Mohsin Amjad
  • 1,045
  • 6
  • 14
0
votes
1 answer

pg_autofailover setup with password

I have created the postgres with pg_auto failover on one primary and one secondary node . I am followed this link. https://www.citusdata.com/blog/2019/05/30/introducing-pg-auto-failover/ I tested the failover and Replication without --auth tag on…
ayan mirza
  • 25
  • 6
0
votes
1 answer

Citus: Can I view sharded tables of each node on master node?

I am managing my PostgreSQL cluster in docker-compose and I have connected to master(coordinator) node via external client. For a given table(for example companies) and a given node number(for example worker 2 or other identifier), can I view…
Haohan Yang
  • 151
  • 1
  • 11
0
votes
1 answer

Is it possible to partitioning a psql table along columns?

At the moment I have several tables with around 4000 columns in sum and approx. 1 Mio. rows each with the same index column. I have build partitioning manually to split these columns into batches of ~1500 (bc. psql max. amount of columns is…
dl.meteo
  • 1,658
  • 15
  • 25
0
votes
1 answer

citus write activity after ingestion is completed

I have a citus cluster of 1 coordinator node (32 vcores , 64 GB RAM) and 6 worker nodes (4 cores , 32 GB RAM each). After performing ingestion of data using the following command where chunks_0 directory contains 300 files having 1M record…
user123
  • 387
  • 1
  • 4
  • 13
0
votes
1 answer

Using joins on non-distributed columns in Citus distributed tables

I have succesfully created a Citus cluster with a couple of worker nodes. I get issues running a query using distributed tables. This is a very simplified version of an indicative query I want to run: SELECT a.origin, a.destination, b.label AS…
user3389819
  • 37
  • 6
0
votes
2 answers

How to link jobs on coordinator and workers on a Citus database on PostgreSQL 12

I have Citus extension on a PostgresSQL server. And I want to see the statistics from pg_stat_statements of each worker through the coordinator node. However, there is no column to match the tables from coordinator and workers. Does anybody know how…
Miguel Wang
  • 183
  • 1
  • 12
0
votes
1 answer

Syncing data to Node that was offline while INSERT-ing (Citus)

I have set my replicaton_factor in Citus to 2 so every node has every data in case that if one Node gets a failure (goes offline) I can stil get all the data. The problem I have is: I don't know how to get data inside of a node that failed while I…
Mega
  • 3
  • 2
0
votes
1 answer

In citusDB, how do I find out how my data is distributed?

In CitusDB, I can create an empty table with: CREATE TABLE table1 (col1 text, col2 text); I can tell table1 how to partition the data, which will later be loaded into the table, by running this: SELECT create_distributed_table('table1',…
BeerIsGood
  • 121
  • 1
  • 7
0
votes
1 answer

Citus "create_distributed_table" giving "PG::UndefinedColumn"

When trying to create a distributed table with Citus, it gives a PG::UndefinedColumn: ERROR: column "x" does not exist I have enabled Citus on workers and main DB: SELECT run_command_on_workers($cmd$ CREATE EXTENSION citus; $cmd$); I created a…
heldopslippers
  • 828
  • 2
  • 9
  • 20
0
votes
1 answer

Azure Hyperscale (Citus) couldn't create database with the citus account

After creating the Azure Hyperscale (Citus) on the Azure portal, I use DbBeaver to access to the created database. I can connect to that database (succeed login to with the citus account and its password on the Azure portal), but when I tried to…
thangchung
  • 2,020
  • 2
  • 17
  • 28
0
votes
1 answer

Citus PostgreSQL single machine cluster to multi machine cluster for Multi-tenant Databse

Design a Database Architecture for a Multi-tenant Application ️ with the following Criteria: Multiple Tenant Types ( different schema for each Tenant with around 20 tables each) starting with 2 should scale to 50+ Tenant Types Each Tenant Type …
SavvyMechanic
  • 1
  • 1
1 2 3
…
8 9