citus
citus copied to clipboard
citusdata
Distributed PostgreSQL as an extension
There is a wall of warnings on our Build & Test actions due to outdated nodejs versions being used by older github actions. This PR update these actions to newer...
Hello, we have a problem that postgresql is crashing when we left join citus table on heap tables. OS Redhat 8.9 , Postgresql 16.3 , Citus 12.1.4 How to reproduce:...
Postgres / pg_dump provides `pg_dump --schema-only ` API so that users can get the schema. We should provide some tooling for including Citus specific commands, like, `create_distributed_table` / `create_reference_table`
Hi all, I use PostgreSQL 15.6 and Citus 12.1 I try to set up replication on worker node with pg_basebackup like this: ` /usr/pgsql-15/bin/pg_basebackup -D /pgsql/15/data -Fp -R -X stream...
Hello Citus Community, I am currently designing a Citus cluster expected to manage over 100TB of data and handle millions of queries. Given the high traffic anticipated, I am concerned...
https://app.circleci.com/jobs/github/citusdata/citus/1208304 ```diff SELECT user_id, array_length(events_table, 1) FROM ( SELECT user_id, array_agg(event ORDER BY time) AS events_table FROM ( SELECT u.user_id, e.event_type::text AS event, e.time FROM users_table AS u, events_table AS...
**Description:** This PR fixes the default calculation for `citus.local_shared_pool_size` when a value is not set for the GUC. The original approach was to divide `citus.client_max_connections` by 2, which could lead...
Running the following SQL query always causes a segmentation fault in Citus 12 with Postgres 16: ``` CREATE TABLE gianluca_camp_test( id BYTEA, account_id BYTEA NOT NULL, start_timestamp INT, PRIMARY KEY(account_id,...
How exactly does citus generate the migration plan in the process of shard rebalancing? I don't know how to get started when I try to read the citus source code,...
Extension `anon` use case requires [SECURITY LABEL ... ON COLUMN](https://postgresql-anonymizer.readthedocs.io/en/stable/#:~:text=%3D%23%20SECURITY%20LABEL%20FOR%20anon%20ON%20COLUMN%20people.lastname%0A%2D%23%20IS%20%27MASKED%20WITH%20FUNCTION%20anon.fake_last_name()%27%3B%0A%0A%3D%23%20SECURITY%20LABEL%20FOR%20anon%20ON%20COLUMN%20people.phone%0A%2D%23%20IS%20%27MASKED%20WITH%20FUNCTION%20anon.partial(phone%2C2%2C%24%24******%24%24%2C2)%27%3B) statements. Citus only propagates SECURITY LABEL ... ON ROLE commands. To enable `anon` extension use cases, we need to propagate...
