citus
citus copied to clipboard
Distributed PostgreSQL as an extension
I have set up a publication and subcription model for replicating data from one database to another. It was working until I have distributed table on subscription server. Now it...
When execute the follow sql. ```sql select * from ( select tt.* from ( select * from dt2 order by a) as tt ) as t ; ``` Subquery with...
(experimental) DESCRIPTION: Add a single connection retry after losing a connection This PR adds a single connection retry in the adaptive executor after losing the connection. That way, we can...
After I remove all node and plan to add node (use another ip and port but still the same server) I get a mistake. Although I removed the database and...
It could be very effective for analytical purpose on historical data to use different compression settings per column basis. For example id/'partitioned by' columns with 'none' uncompressed for fast access,...
Fixes https://github.com/citusdata/citus/issues/5538. Another approach for https://github.com/citusdata/citus/pull/5908 on the connection management level, not the executor. Postgres added support for WL_SOCKET_CLOSED on PG 15 (https://github.com/postgres/postgres/commit/50e570a59e7f86bb41f029a66b781fc79b8d50f1) for kernels that support this event. This...
One thing that makes debugging rebalancer issues hard is that it does not forward SET commands when it connects to localhost to execute `citus_move_shard_placement()`. Most importantly it does not forward...
Using parallel futures in an atexit callback is not supported by Python and will result in an error like this being shown: ``` RuntimeError: cannot schedule new futures after interpreter...
DESCRIPTION: Fixes a performance issue when there are subplans and local shards We were raising ExecutorLevel in CitusExecutorRun before executing subplans, which caused subplans to consider themselves nested executions, which...
When connecting to a worker, we only show distributed tables even though the shards are in the same schema. However, we only hide shards that are in the metadata, and...