Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
0 votes
0 answers
28 views

I use schema-based sharding strategy and Citus 12.1 We have SaaS, so we use schema-per-tenant approach. In our system users often make requests of time series data for period of time for a special ...
0 votes
1 answer
40 views

For Azure Cosmos Postgre/CITUS i.e COSMOS POSTGRE API for a distributed table, SQL MERGE is not supported, getting below exception. Not sure, what could be exact reason for this? Any alternate method/...
0 votes
1 answer
73 views

I'm using Citus 12.1 on top of PostgreSQL, and I have a distributed table with range partitioning. When I try to update a row and change the value of the partition key, I get the following error: ...
1 vote
0 answers
57 views

I recently use Alfresco CE 23.2 version and try to extend it with distribution features. My environment: PostgreSQL: 15.9 Citus:13.0.1 I have created corresponding files of SQL in the source code &...
0 votes
2 answers
83 views

In a past job I worked with financial tick data, a time series of events where each event/record is about 100 bytes and has 15-20 columns. A full time series has order 1e12 events quickly growing to ...
2 votes
1 answer
120 views

i have Citus that i run from docker-compose, i took yaml from official site and ran it initially from 2 nodes docker-compose -p citus up --scale worker=2 -d Afterwards i add the table CREATE TABLE ...
Oleg Pro's user avatar
  • 123
2 votes
2 answers
608 views

How to install Citus extension for postgresql-17? I have been looking for it on many search portals. My intention is to install Citus extension for Postgres-17 version, any help much appreciated. I ...
1 vote
1 answer
73 views

I have 2 tables in postgres, which are present in the separate schemas under same database. While executing the SQL using the join between these 2 tables, getting the error as table1 and table2 are ...
Pranav's user avatar
  • 395
0 votes
1 answer
93 views

Citus does not natively support triggers on distributed tables, but there is an official workaround on their site. The way to do this is to create the table (without the trigger) create function the ...
1 vote
1 answer
141 views

I would like to know how to drop the database on citus cluster. In my Postgres cluster, I have 1 controller and 2 worker nodes. Is there any suggested way of dropping the database in citus cluster? ...
Saran's user avatar
  • 945
1 vote
1 answer
71 views

I have implemented custom aggregation in regular PostgreSQL, which is partially aggregates and is parallelized. It also runs on the whole table. Now, I am trying to use citus to distribute the table ...
0 votes
1 answer
164 views

I am using Citus as a managed service in the cloud with Azure Cosmos DB for PostgreSQL. I have 1 coordinator and 2 worker nodes setup. There are distributed tables and reference tables created. ...
0 votes
0 answers
181 views

We want to setup patroni HA setup with 3 coordinator, 2 worker node 1 & 2 worker node 2. I am getting system id mismatch when i start 2nd coordinator. First one is running fine, only facing issue ...
1 vote
1 answer
657 views

I want to set up a cluster in Docker that contains citus + patroni and the corresponding etcd for Postgres I have this dockerfile: FROM postgres:16 RUN apt-get update && \ apt-get install ...
0 votes
1 answer
397 views

I was running some SQL query and got the error: sqlalchemy.exc.InternalError: (psycopg2.errors.InternalError_) the query contains a join that requires repartitioning HINT: Set citus....

15 30 50 per page
1
2 3 4 5
...
10

AltStyle によって変換されたページ (->オリジナル) /