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
Citus logs show error after upgrade to 11.2
I have upgraded Citus extension from 10.2 to 11.2 running on postgres version 14. I disabled the version checks for citus and was able to apply the extension to database for the coordinator and workers nodes and than on coardinator node, I did run…
Devaddy
- 45
- 6
0
votes
1 answer
Citus upgrade failed
I am running citus in kubernetes and trying to do an upgrade from 10.2 to 11.2, the underneath postgres version is 14.
Image used in deployment for upgrade: citusdata/citus:11.2-pg14
After performing the upgrade with image citus:11.2-pg14 , pod goes…
Devaddy
- 45
- 6
0
votes
0 answers
Postgres running in kubernetes throws an error PANIC could not locate a valid checkpoint record
I am running postgres in kubernetes and I am seeing the below error.
PANIC could not locate a valid checkpoint record
How do I recover from this error as it goes in to crashloobackoff and I couldn't find a way to recover and also how do I make sure…
Devaddy
- 45
- 6
0
votes
1 answer
Citus: shard_size is empty
Citus 11.1.5
select * from citus_shards return many rows, but field shard_size is empty.
I expect that field shard_size from citus_shards table are not be empty.
I need to calculate size of all shards.
Yuriy
- 1
0
votes
1 answer
Citus parallelism limitations
I'm experimenting with Citus extension for PostgreSQL to enable parallelism for my analythics queries (single node setup). I have a very simple UPDATE statement for a distributed table which runs perfectly parallel when execute from the IDE…
leonidovich
- 1
- 2
0
votes
1 answer
Citus: pg_stat_all_tables is empty
I need to get table usage info.
But if I run the select * from pg_stat_all_tables I see zero or null values along citus tables.
The same result on coordinator and worker node.
How can I get the tuple usage, vaccum time execution at the Citus…
Yuriy
- 1
0
votes
0 answers
How can to use ltree extension without using public schema in Azure hyperscale citus database?
My application database is deployed on Azure citus database which requires ltree extension for one of its schema. Currently the queries from my java application do not work since ltree extension is enabled/works for public schema only. While testing…
Fahad
- 1
0
votes
1 answer
CITUS - WARNING: Not allowed to move shard anywhere from :
I am trying out the Citus PSQL extension for sharding, and am trying the custom rebalancing strategies. I created the following function that is meant to check the current shardid's groupid against a table called geo_node with all countries and…
0
votes
1 answer
citus:truncate records of a table
I want to use sql command truncate table to truncate all records in a distributed table of citus,but seems it doesn't work,so I have to login to each datanode to truncate each shard of the table. so,
can i use truncate table to delete all records in…
genhua
- 1
0
votes
1 answer
Postgres-15.1 is restarting continuously on using shared_preload_libraries extension
Postgres is restarting continuously on using shared_preload_libraries extension.
https://postgresqlco.nf/doc/en/param/shared_preload_libraries/
I am running postgres-15.1 using a python-based daemon in CentOS7-32bit arch. It is working fine if we do…
Vishal Gupta
- 23
- 4
0
votes
0 answers
How to query JSONB column with nested array & objects in Citus postgres
I have a Postgres Table "Organization" containing "email_details" column of JSONB data.
This column will hold data in below format.
{
"emails":
[
{
"recipients": ["abc_email@dummy.com", "xyz_email@dummy.com"],
…
Tanuj Kathuria
- 43
- 6
0
votes
1 answer
citus: Can I add one more replica for a distributed table
I have a distributed table,but this table only has one replica,only one replica doesn't have
ha, I want and one more replica for the table,can i? how to do?
I have search online help docs,but didn't find any solution.
hegenhua
- 1
0
votes
2 answers
add worker node and rebalance distributed shards problem with PostgreSQL + Citus
The cluster had 1 coordinator and 6 worker nodes. (environment: PostgreSQL 15 + Citus 11.1)
We want to add more worker nodes to it, so we executed
SELECT * from citus_add_node('node-name', 5432);
and
SELECT rebalance_table_shards('table_name'); to…
bluefish
- 1
- 1
0
votes
1 answer
Delete in Postgres citus columnar storage alternatives
I am planning to use citus to store system logs for upto n no of days after which they should be deleted.Citus columnar store looked like the perfect database for this until I read
this where its mentioned no deletes can be performed on…
Raj Patil
- 1
- 1
0
votes
2 answers
Postgresql doesn't working with Citus and pg_stat_statements at the same time
So, I built the PostgreSQL with citus extension in docker.
I use the official documentation in citus, then I run this command in the terminal.
docker run -d --network citus-network --name citus_coordinator -p 5500:5432 -e…
Gismat Gusein
- 31
- 6