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 does not scale out in my test environment

I have setup a Citus environment: (Citus 7.2.2, Postgres 10.12) 1) 1x coordinator node 2) 5x worker nodes 3) (2GB mem and 2cores VM's for each of the 6 nodes) I used pgbench with built-in sql (e.g. simple-update, select-only, tpc-b). As I added…
David Fang
  • 1
0
votes
1 answer

Unable to connect to CitusData - SQLSTATE[08006] error

I am getting an issue with CitusData docker version on MAC. SQLSTATE[08006] [7] could not connect to server: Connection refused List of docker containers below: ba187040a5ca citusdata/citus:8.2.2 "docker-entrypoint.s…" …
Jatin Thapar
  • 67
  • 2
  • 7
0
votes
1 answer

Backfilling missing data against a timeseries without using <= join?

I have a table that follows roughly this schema: Table Name: history ╔════╤══════╤══════════╤═════╤═════════════════════╗ ║ id │ stat │ stat_two │ ... │ updated_at ║ ╠════╪══════╪══════════╪═════╪═════════════════════╣ ║ 1 │ 100 │ 5 …
Ivan
  • 33
  • 6
0
votes
1 answer

Poor performance when grouping by timestamptz difference

I have a query which LEFT JOINing two tables with timestamptz columns and grouping result by (date_trunc( 'DAY', "table_one"."ttz" AT TIME ZONE 'America/Los_Angeles' ) - date_trunc( 'DAY', "table_two"."ttz" AT TIME ZONE …
Ivan Vyazmitinov
  • 11
  • 2
0
votes
1 answer

Citus: make existing database as worker node of citus

I already have a database on one of my server used by a web app. Lets say D1 I want to make a new web app with new database D2 on some other server with some relations with D1. I want to create citus data server and add both D1 and D2 as shard table…
wrufesh
  • 1,379
  • 3
  • 18
  • 36
0
votes
1 answer

How to create_reference_table from another DB (not postgres)?

I trying to create new db, when tables in it, then make them distributed, but can't use create_reference_table() in new db (it's not found). If I try to run create_reference_table('newbie.schema.new_table) I will get error "ERROR: cross-database…
40min
  • 117
  • 1
  • 9
0
votes
1 answer

How to workaround unsupported percentile_cont in Postgres/Citus?

I have a query similar to this: select coalesce(s.import_date, r.import_date) as import_date, coalesce(s.bedrooms, r.bedrooms) as bedrooms, coalesce(s.ptype, r.ptype) as property_type, s.s_price, s.s_transactions, …
Randomize
  • 8,651
  • 18
  • 78
  • 133
0
votes
1 answer

Which schema should I choose on citus deployment

I installed a multi machine cluster using citus following this docs (1 coordinator, 2 nodes). After finish the installation guide I noticed that is created a citus schema besides default public schema. Also the default configuration pointing to…
Juan I. Morales Pestana
  • 1,057
  • 1
  • 10
  • 34
0
votes
0 answers

Use power of 2 machines(HW) for one postgresql DB

Here is the thing. I have a report databse which is used by pentaho, for generating reports. This DB is running on the same machine as pentaho-server (v7.1). This report DB is being filled from about 90 other databases spread across the country.…
rRr
  • 370
  • 1
  • 5
  • 17
0
votes
1 answer

Is there a default user created during Citus AWS CloudFormation?

I have created a Citus DB cluster using the Cloud Formation template here: Multi-Machine AWS Citus Cloud Formation I can login to the DB using CLI once I go to the host in PuTTy. This does not require a username/pwd. And, this runs…
Jason
  • 2,006
  • 3
  • 21
  • 36
0
votes
1 answer

Is it possible to do Sharding in PostgreSQL without any extra plugin?

I want to do sharding in postgresql without using citus plugin. can anybody suggest how to do ?
kumar
  • 441
  • 4
  • 9
0
votes
0 answers

how to scale horizontal database

I'm developing an app that consumes web api. If you have too many users and the database server starts to slow down. I would like some tips how to climb it. It was insane they control everything by the application. I have not yet chosen which sgbd…
user2514644
  • 39
0
votes
1 answer

Citus: is a 2 node PGSQL cluster doable and if yes how?

I am thinking of using Citus opensource for dualnode cluster - my questions are basically 2: - if this kind of clustering is available - in the case of a failover is the slave node promoted to master? If yes - how - does it use WAL? - If such a way…
qubsup
  • 1,241
  • 5
  • 15
  • 23
0
votes
1 answer

Postgresql sharding with citus extension not working

I am using Postgresql with citus extension for sharding and unable to shard tables like below. Below table has a primary key and 2 unique keys. I am trying to shard against column with primary key i.e pid. Note: I am not allowed to change the table…
Gautham.R
  • 29
  • 6
0
votes
1 answer

CitusDB append distribution on non-numeric column

I am reading the CitusDB documentation here: https://docs.citusdata.com/en/v6.1/reference/append.html and I understand the mechanics of how append distribution works. However, I would like to know if the append distribution would work on non-numeric…
Sundar Venkataraman
  • 3
  • 4
1 2 3
…
8
9