citus
citus copied to clipboard
Distributed PostgreSQL as an extension
Steps to reproduce: ```SQL -- create tables and distribute them CREATE TABLE table_a (tenant_id uuid, id int); CREATE TABLE table_b (tenant_id uuid, id int); SELECT create_distributed_table('table_a', 'tenant_id'); SELECT create_distributed_table('table_b', 'tenant_id',...
I have three node setup. 1 coordinator and 2-workers. I am using replication slot from quite some time. It was working fine. But after updating to 13.0.1 i face this...
recently, I use the bingo extension from https://github.com/epam/Indigo, which has the following definintion ``` CREATE OPERATOR CLASS bmolecule FOR TYPE bytea USING bingo_idx AS OPERATOR 1 public.@ (bytea, sub), OPERATOR...
## Problem Description I'm setting up a PostgreSQL cluster using Citus and Patroni. While I've successfully added worker nodes to the cluster, the system doesn't seem to recognize them as...
PosgreSQL's `jsonb_build_object()` over columnar tables consumes excessive memory and leads to OOM crash. --- Hi team, I'm running into what appears to be a memory leak when executing a GROUP...
See https://github.com/pgaudit/pgaudit/pull/260 for a report against another project using syntax `SET search_path = 'pg_catalog, pg_temp'`. A search of PGXN for `'pg_catalog,` turned up one match in a citus test. While...
Citus allows to customize the distribution strategy of shards by defining custom re-balance strategies, for instance moving a schema to a specific shard and giving weightage to specific nodes in...
Add check for shift size, reset to zero in case of overflow Fix #7953
### What problem does the new feature solve? [pglite](https://pglite.dev) is a (relatively) new tool that allows running postgres in WASM (which allows it to run in-memory, or in the browser)...
## Symptom Citus version: `Citus 13.0.1 on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit` Postgres version: `PostgreSQL 17.2 (Debian 17.2-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit`...