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

PostgreSQL Citus Shard Rebalancing after adding new node -> connection to the remote node localhost:5432 failed with the following error

Here I have a problem while applying Citus rebalancing after distributing a specific PostgreSQL table and adding new nodes to scale my database. You can take a look at this useful article if you would like to understand rebalancing in citus before…
Uncle Bent
  • 163
  • 1
  • 1
  • 11
2
votes
1 answer

Best Approach for Developing a SaaS-based Event Analytics

My company is developing a SaaS service to store events and provide analytics through dashboards. Since we won't have deletes or updates, the idea is to create a columnar-based, OLAP architecture to benefit from compression and latency it provides,…
Alvaro Seixas
  • 23
  • 2
2
votes
2 answers

How to set Postgres tables to use columnar storage using dbt?

We are using dbt to manage our data models in MSSQL, and we are considering moving to PostgreSQL Citus. I'm not clear on how I could use Citus's features via dbt? I'm thinking specifically of data compression and columnar storage. Any ideas?
MYK
  • 1,988
  • 7
  • 30
2
votes
1 answer

Migrate data from Citus to RDS

Since Citus is not going to be available as a Managed Service in AWS, I am trying move the database to RDS (not the whole history but only the transactional portion as an OLTP). The migration from Citus is not clear because the data does not reside…
Victor Cadena
  • 191
  • 2
  • 7
2
votes
1 answer

Support for Citus in production? Community or Premium?

We've been building a system that is using Citus db and we are considering purchasing the premium support option before going into production, however costs are relatively high. My analysis of the community is that is quite small and niche, although…
Milodude
  • 67
  • 3
2
votes
2 answers

Combine NoSQL and Relational Database on single Postgresql instance

I have an existing relational Postgresql database. A few of the tables contain very fat blobs, they would be much better of as NoSQL Documents. This would significantly lighten our relational database. So, we thought of moving those blob-table out…
gaukhar
  • 182
  • 2
  • 14
2
votes
1 answer

Django - NEVER update a column when saving

I am trying to use citus data (https://www.citusdata.com/) with Django. Most everything is working so far, except trying to save a model that has already been saved: NotSupportedError: modifying the partition value of rows is not allowed This is…
synic
  • 26,359
  • 20
  • 111
  • 149
2
votes
2 answers

All distributed queries fail using Citus task tracker executor

I'm attempting to performance-test distributed joins on Citus 5.0. I have a master and two worker nodes, and a few hash distributed tables that behave as expected with the default config. I need to use the task tracker executor to test queries that…
Franklin Dingemans
  • 23
  • 3
2
votes
2 answers

Using CitusDB with SQL-alchemy

I am using caravel with CitusDB and I am running into problems connecting to the database node. To be frank, I have no clue what to do. I followed the official installation instructions to install and run. I can log into the running master using the…
manu29.d
  • 1,538
  • 1
  • 11
  • 15
2
votes
1 answer

Does CitusDB support `CREATE VIEW`?

Assume we have a distributed CitusDB table named customer_reviews, and we try to create a view on it: CREATE VIEW book_reviews AS (SELECT * FROM customer_reviews WHERE product_group = 'Book'); This appears to work. But if we run: SELECT COUNT(1)…
emk
  • 60,150
  • 6
  • 45
  • 50
2
votes
1 answer

Connection with a PostgreSQL foreign table

I'm using citus columnar extension cstore_fdw for PostgreSQL (I'm on 9.4.1). I create the foreign table without any problem. The problem starts in R when I try to write into it. A normal dbWriteTable command does not work: cba <- dbWriteTable(conpg,…
Enzo
  • 2,543
  • 1
  • 25
  • 38
1
vote
1 answer

Distributed Sequence generation - Citus

We are using sequence generator to generate the sequence. Ex: Every time when a row is inserted there is one more column which uses sequence to create strings like R0001, R0002 etc. We want this sequence to be re-started for every shard. We are…
ManojAnavatti
  • 604
  • 1
  • 7
  • 18
1
vote
1 answer

Using RDS instances as Citus worker nodes

I am considering using Citus because my app is text-book multitenancy app and my problems are exactly what Citus is meant to solve (some tenants are starting to grow so big that they are starting to affect other tenants processes). Schema-wise I'd…
Tarmo
  • 3,851
  • 2
  • 24
  • 41
1
vote
0 answers

postgresql citus: ctas with select on table with columnar storage runs in error, same select with select on non-columnar storage works

We run a postgresql 14 with citus_columnar in version 11.1. Scenario 1: select on 3 tables, where 2 two tables are partitioned and "using columnar". This works pefectly Scenario 2: the same select, but with create table as. Here comes an…
db_wh_en
  • 11
  • 1
1
vote
0 answers

Resolve debug symbols for postgres

I am working on an adding a new extension on citus and am in the process of collecting and analyzing the stack traces for the extension, postgres, citus and other libs by running ycsb workloads against a cluster. I am using perfcollect to collect…
unujjwal
  • 11
  • 3
1
2
3
…
8 9