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
0 answers

ERROR: attempted to read an unexpected stripe while reading columnar table daily_p2022_10_11, stripe with id=281134 is not flushed

I am getting this error in postgres alert log: ERROR: attempted to read an unexpected stripe while reading columnar table daily_p2022_10_11, stripe with id=281134 is not flushed. While trying vacuum, getting below : ccap_proddb=> vacuum verbose…
user2873848
  • 1
0
votes
0 answers

'another command is already in progress' returned when trying to rebalance shards

There are two Postgres instances running in a Citus cluster: analysis=# select * from citus_check_cluster_node_health(); from_nodename | from_nodeport | to_nodename | to_nodeport |…
eskaes
  • 75
  • 2
  • 5
0
votes
1 answer

Citus - Possible to undo citus's create_time_partitions results?

I'm working on a database with Citus and I would like to know if it's possible to undo the results made by executing create_time_partitions. I know that it is possible to "undistribute" a distributed Citus table, but I want to be able to merge the…
user1934283
  • 124
  • 4
  • 15
0
votes
1 answer

Citus data - How to query data from a single shard in a query?

We are evaluating Citus data for the large-scale data use cases in our organization. While analyzing, I am trying to see if there is a way to achieve the following with Citus data: We want to create a distributed table (customers) with customer_id…
Narayanababu
  • 145
  • 1
  • 7
0
votes
0 answers

Citus support the HA? ( High Availability )

i have one simply question: citus 11 support the HA? This is the structure that i have implemented with 7 node ( replication with pg_autofailover): The problem occurs when i disable a worker1_primary and i try to make an sql insert in the…
Al3
  • 183
  • 1
  • 3
  • 11
0
votes
1 answer

pg_auto_failover Installation fails on Rocky linux

I want to install pg_auto_failover(https://github.com/citusdata/pg_auto_failover) on rocky linux 8.5 . But when I key in the following install command: (1) curl https://install.citusdata.com/community/rpm.sh | sudo bash the console shows the error…
吳宗霖
  • 1
  • 1
0
votes
1 answer

Create a PostgreSQL Hyperscale Citus DB from Azure CLI (not ARC)

How do I create a hyperscale PostgreSQL DB from the Azure CLI? Please note, I am not asking about Arc-enabled Kubernetes clusters. The current documentation is for Portal only. Is there a way to do this from the Azure CLI?
mobiusinversion
  • 343
  • 1
  • 6
  • 17
0
votes
1 answer

curl Unfortunately,your operating system distribution and version are not supported by this script

my operating system is rocky8.5。when i execute “curl https://install.citusdata.com/community/rpm.sh | sudo bash”，tell me “Detected operatiog system as rocky/8 Unfortunately,your operating system distribution and version are not supported by this…
scott
  • 11
  • 1
0
votes
1 answer

Postgres Citus, immutable date conversion

Trying to update some dates programmatically on Citus I always get [0A000] ERROR: STABLE functions used in UPDATE queries cannot be called with column references From a query like UPDATE date_container SET json_value = json_value::jsonb -…
M4rk
  • 2,172
  • 5
  • 36
  • 70
0
votes
1 answer

Citus Sharding and PostgreSQL table partitioning on the same column

We are starting a project with PostgreSQL and will need to use Citus in the near future for a multi tenant application so we are aiming at preparing our PostgreSQL database schema appropriately for an easy upgrading to Citus. I was reading the…
Christian
  • 420
  • 1
  • 8
  • 15
0
votes
1 answer

citus, which column can be treated as distribution column

I'm a newbie of citus and need an advice that which column will be treated as distribution column when create_distributed_table. Exp 1, the snapshot table of order, every row containing an unique order info, the 3 fields, order_id, create_date,…
William Que
  • 49
  • 4
0
votes
1 answer

Increasing shards in Citus

How can we add shards to existing colocated tables in citus? I found out that the default is 32, which is definitely lower than expected. Is there a easy way of resizing without downtime?
M4rk
  • 2,172
  • 5
  • 36
  • 70
0
votes
0 answers

testing replication from Citus to my RDS Aurora Postgres on subscriber no data is coming

I am testing replication from Citus(Cloud Hosted) to my RDS Aurora Postgres with ref https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Replication.Logical.html#AuroraPostgreSQL.Replication.Logical.Configure Everything ran…
Ashish Karpe
  • 5,087
  • 7
  • 41
  • 66
0
votes
2 answers

Citus 10.2 not starting an instance of PostgreSQL

I'm using RHEL 8.4 and I followed the installation instruction at Set up a single-node Citus cluster on your own Linux machine from RPM packages.. Step 1 and 2 (Install PostgreSQL 14 and the Citus extension and Initialize the Cluster) went through…
Rk..
  • 753
  • 1
  • 10
  • 27
0
votes
1 answer

measure tpc-ds benchmark on citus

I'm trying to do some measurement on citus (extension of postgres). for that mission I'm running tpc-ds query on citus. the citus that I'm using is a containers of master, workers and manager that taken from here:…
etiel
  • 43
  • 5
1 2 3
…
8 9