citus
citus copied to clipboard
citusdata
Distributed PostgreSQL as an extension
Hi. I did not find information in the documentation about scenarios for restoring a cluster from a backup. I consider 2 main scenarios for the case of restoring from a...
testdb=# CALL alter_old_partitions_set_access_method( 't_test_base_info', '2023-09-01 00:00:00', 'columnar' ); NOTICE: converting t_test_base_info_p2023_08_30 with start time 2023-08-30 00:00:00 and end time 2023-08-31 00:00:00 NOTICE: creating a new table for public.t_test_base_info_p2023_08_30 NOTICE: moving...
With https://github.com/citusdata/citus/pull/7240, we expanded our DDL support to support propagating CREATE / DROP DATABASE commands as well as the GRANTs on those distributed databases. However, for the database where Citus...
Today, for database commands that cannot be executed in a transaction block (**), we don't do much next time when the command is invoked, if the prior invocation failed in...
Simple ACID-test (sum calculation under pgbench), PostgreSQL 15.1/Citus 12.1 1. Prepare data: ```sql CREATE TABLE table_a ( id bigint not null , shard_n int not null , value int not...
Is there a technical reason you can only create worker nodes with the same specs or just the way it was decided to sell it on Azure? There are use...
Has there been any thought into how Citus could manage multiple schemas with the same table structure? There could be a master template schema and then a Citus command that...
I am documenting here some flaky tests I have ran into the past weeks, but none of them have extra investigation. - [ ] `subquery_in_where` needs order by https://github.com/citusdata/citus/actions/runs/19567084981/attempts/1#summary-56032048177 ```diff...
I have installed postgresql15.2 and sudo apt-get install postgresql-15-citus-11.3, but when i create extension citus, it's error: Error: Invalid type integer Input syntax: "d" Background: PL/pgSQL function inline_code_block on line...
