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
Questions tagged [citus]
131 questions
0
votes
0 answers
How to check whether the cstore FDW is present on a citus build of PostgreSQL?
I am running citus PostgreSQL build from here:
https://github.com/citusdata/docker/blob/master/docker-compose.yml
But I don't know how to check whether the instance has the cstore foreign data wrapper available for columnar support? I'm guessing…
David Watson
- 3,394
- 2
- 36
- 51
0
votes
1 answer
insertion in Citus hash distributed tables using JDBC in Pyspark
I am trying to insert some data in a hash distributed table which I created using Citus. And in Pyspark I am using JDBC postgres drives to insert data into tables.
code which I am using to insert data into tables using JDBC in pyspark is:
url =…
divya nagar
- 33
- 1
- 6
0
votes
4 answers
Scale OLTP solutions
I'm looking for a way to scale the infrastructure at my work place.
Currently there is only one database with the size of ~1.5TB.
Most of the queries are OLTP type like insert, update, delete.
I was thinking about sharding the database using…
Bogdan Boamfa
- 395
- 2
- 18
0
votes
1 answer
What does this mean and how to fix citus error?
For the query:
SELECT
cu.id id,
cu.email email,
SUM(case when(rt.type = 'credit' and ( re.type = 'account_refilling' OR re.type = 'site_publishing' OR re.type = 'tariff_buying' )) then rt.amount else 0 end ) transactions_sum
FROM…
Eugen Konkov
- 22,193
- 17
- 108
- 158
0
votes
1 answer
Can not set `task_executor_type`
When I trying to put citus cluster configuration value into postgresql.conf file:
citus.task_executor_type = "task-tracker"
I got the error:
service postgresql restart
Error: Invalid line 637 in /etc/postgresql/9.5/main/postgresql.conf:…
Eugen Konkov
- 22,193
- 17
- 108
- 158
0
votes
1 answer
Is there an example dataset to illustrate cstore_fdw's performance benefits?
I went through the examples in the Citus quick start guide with the customer_reviews dataset. It works great, but the performance on the same dataset in a regular PostgreSQL table was pretty good too. I suspect it's because the dataset might fit in…
wrschneider
- 17,913
- 16
- 96
- 176
-1
votes
1 answer
Citus-Postgres Custom Distribution Logic
I am working with Citus-Postgress to setup a cluster of coordinator and worker nodes and distribute table data across these nodes. By default, Citus uses its own logic to automatically distribute shards across the worker node.
However, I would like…
Gagandeep Singh
- 827
- 1
- 7
- 11
-1
votes
1 answer
I am unable to install citus version 10.2 on my ubuntu 21.04
I am unable to install citus version 10.2 on my ubuntu 21.04
with the following errors :
E: Unable to locate package postgresql-14-citus-10.2
E: Couldn't find any package by glob 'postgresql-14-citus-10.2'
E: Couldn't find any package by regex…
-1
votes
1 answer
NPGSQL Drivers and Azure Database for SQL - Hyperscale Citus compatibility
We are migrating our Postgresql v10 (Linux) database to Azure and due to the timeframe involved would prefer not to change our current use of the npgsql driver in our apps.
Has anyone had any experience here? Can we utilize our use of that driver…
cdm
- 1
-1
votes
1 answer
Connect CitusData with PHP/Laravel
I have followed the instructions to setup the CitusData Single Cluster using Docker.
When I try to use this with Laravel then this does not work and this throws for Connection Refused.
Any idea to resolve this?
Xyrin Technologies
- 229
- 3
- 14