- Removes pg_send_cancellation and all references (#7135)
- Fixes the incorrect column count after ALTER TABLE (#7379)
-
Fixes incorrect default value assumption for VACUUM(PROCESS_TOAST) #7122)
-
Fixes a bug that causes an unexpected error when adding a column with a NULL constraint (#7093)
-
Fixes a bug that could cause COPY logic to skip data in case of OOM (#7152)
-
Fixes a bug with deleting colocation groups (#6929)
-
Fixes memory and memory contexts leaks in Foreign Constraint Graphs (#7236)
-
Fixes shard size bug with too many shards (#7018)
-
Fixes the incorrect column count after ALTER TABLE (#7379)
-
Improves citus_tables view performance (#7050)
-
Makes sure to disallow creating a replicated distributed table concurrently (#7219)
-
Removes pg_send_cancellation and all references (#7135)
-
Disallows MERGE when the query prunes down to zero shards (#6946)
-
Fixes a bug related to non-existent objects in DDL commands (#6984)
-
Fixes a bug that could cause COPY logic to skip data in case of OOM (#7152)
-
Fixes a bug with deleting colocation groups (#6929)
-
Fixes incorrect results on fetching scrollable with hold cursors (#7014)
-
Fixes memory and memory context leaks in Foreign Constraint Graphs (#7236)
-
Fixes replicate reference tables task fail when user is superuser (#6930)
-
Fixes the incorrect column count after ALTER TABLE (#7379)
-
Improves citus_shard_sizes performance (#7050)
-
Makes sure to disallow creating a replicated distributed table concurrently (#7219)
-
Removes pg_send_cancellation and all references (#7135)
-
Fixes a bug in background shard rebalancer where the replicate reference tables task fails if the current user is not a superuser (#6930)
-
Fixes a bug related to non-existent objects in DDL commands (#6984)
-
Fixes a bug that could cause COPY logic to skip data in case of OOM (#7152)
-
Fixes a bug with deleting colocation groups (#6929)
-
Fixes incorrect results on fetching scrollable with hold cursors (#7014)
-
Fixes memory and memory context leaks in Foreign Constraint Graphs (#7236)
-
Fixes the incorrect column count after ALTER TABLE (#7379)
-
Improves failure handling of distributed execution (#7090)
-
Makes sure to disallow creating a replicated distributed table concurrently (#7219)
-
Removes pg_send_cancellation (#7135)
-
Fixes memory and memory context leaks in Foreign Constraint Graphs (#7236)
-
Fixes a bug related to non-existent objects in DDL commands (#6984)
-
Fixes a bug that could cause COPY logic to skip data in case of OOM (#7152)
-
Fixes a bug with deleting colocation groups (#6929)
-
Fixes incorrect results on fetching scrollable with hold cursors (#7014)
-
Fixes the incorrect column count after ALTER TABLE (#7379)
-
Improves failure handling of distributed execution (#7090)
-
Makes sure to disallow creating a replicated distributed table concurrently (#7219)
-
Removes pg_send_cancellation and all references (#7135)
-
Fixes a bug that could cause COPY logic to skip data in case of OOM (#7152)
-
Fixes a bug with deleting colocation groups (#6929)
-
Fixes memory and memory context leaks in Foreign Constraint Graphs (#7236)
-
Fixes the incorrect column count after ALTER TABLE (#7462)
-
Improve failure handling of distributed execution (#7090)
-
Fixes leaking of memory and memory contexts in Citus foreign key cache (#7236)
-
Makes sure to disallow creating a replicated distributed table concurrently (#7219)
-
Adds support for PostgreSQL 16.0 (#7173)
-
Add
citus_schema_move()
function which moves tables within a distributed schema to another node (#7180) -
Adds
citus_pause_node_within_txn()
UDF that allows pausing the node with given id (#7089) -
Makes sure to enforce shard level colocation with the GUC
citus.enable_non_colocated_router_query_pushdown
(#7076) -
Allows creating reference / distributed-schema tables from local tables added to metadata and that use identity columns (#7131)
-
Propagates
BUFFER_USAGE_LIMIT
option inVACUUM
andANALYZE
(#7114) -
Propagates
PROCESS_MAIN
,SKIP_DATABASE_STATS
,ONLY_DATABASE_STATS
options inVACUUM
(#7114) -
Propagates
GENERIC_PLAN
option inEXPLAIN
(#7141) -
Propagates "rules" option in
CREATE COLLATION
(#7185) -
Propagates
GRANT
/REVOKE
for database privileges (#7109) -
Adds TRUNCATE trigger support on Citus foreign tables (#7170)
-
Removes
pg_send_cancellation
(#7135) -
Prevents unnecessarily pulling the data into coordinator for some
INSERT .. SELECT
queries that target a single-shard group (#7077) -
Makes sure that rebalancer throws an error if replication factor is greater than the shard allowed node count. Also makes sure to avoid moving a shard to a node that it already exists on. (#7074)
-
Fixes a bug that may appear during 2PC recovery when there are multiple databases (#7174)
-
Fixes a bug that could cause
COPY
logic to skip data in case of out-of-memory (#7152) -
Fixes a bug that causes an unexpected error when adding a column with a
NULL
constraint (#7093) -
Fixes
PROCESS_TOAST
default value totrue
(#7122) -
Improves the error thrown when there is datatype mismatch in
MERGE ON
(#7081)
-
Adds support for schema-based sharding. While
citus.enable_schema_based_sharding
GUC allows sharding the database based on newly created schemas,citus_schema_distribute()
allows doing so for the existing schemas. Distributed schemas used for sharding the database can be listed by using the viewcitus_schemas
, monitored by using the viewcitus_stat_schemas
, and undistributed by using the udfcitus_schema_undistribute()
(#6866, #6979, #6933, #6936 and many others) -
Supports MERGE command across non-colocated distributed tables/subqueries, reference tables and joins on non-distribution columns (#6927)
-
Drops PG13 Support (#7002, #7007)
-
Changes default rebalance strategy to by_disk_size (#7033)
-
Changes by_disk_size rebalance strategy to have a base size (#7035)
-
Improves citus_tables view performance (#7018)
-
Improves tenant monitoring performance (#6868)
-
Introduces the GUC
citus.stat_tenants_untracked_sample_rate
for sampling in tenant monitoring (#7026) -
Adds CPU usage to citus_stat_tenants (#6844)
-
Propagates
ALTER SCHEMA .. OWNER TO ..
commands to worker (#6987) -
Allows
ADD COLUMN
in command string with other commands (#7032) -
Allows
DROP CONSTRAINT
in command string with other commands (#7012) -
Makes sure to properly handle index storage options for
ADD CONSTRAINT
/ COLUMN commands (#7032) -
Makes sure to properly handle
IF NOT EXISTS
forADD COLUMN
commands (#7032) -
Allows using generated identity column based on int/smallint when creating a distributed table with the limitation of not being able perform DMLs on identity columns from worker nodes (#7008)
-
Supports custom cast from / to timestamptz in time partition management UDFs (#6923)
-
Optimizes pushdown planner on memory and cpu (#6945)
-
Changes citus_shard_sizes view's table_name column to shard_id (#7003)
-
The GUC search_path is now reported when it is updated (#6983)
-
Disables citus.enable_non_colocated_router_query_pushdown GUC by default to ensure generating a consistent distributed plan for the queries that reference non-colocated distributed tables (#6909)
-
Disallows MERGE with filters that prune down to zero shards (#6946)
-
Makes sure to take
shouldhaveshards
setting into account for a node when planning rebalance steps (#6887) -
Improves the compatibility with other extension by forwarding to existing emit_log_hook in our log hook (#6877)
-
Fixes wrong result when using
NOT MATCHED
with MERGE command (#6943) -
Fixes querying the view
citus_shard_sizes
when there are too many shards (#7018) -
Fixes a bug related to type casts from other types to text/varchar (#6391)
-
Fixes propagating
CREATE SCHEMA AUTHORIZATION ..
with no schema name (#7015) -
Fixes an error when creating a FOREIGN KEY without a name referencing a schema qualified table (#6986)
-
Fixes a rare bug which mostly happens with queries that contain both outer join and where clauses (#6857)
-
Fixes a bug related to propagation of schemas when pg_dist_node is empty (#6900)
-
Fixes a crash when a query is locally executed with explain analyze (#6892)
-
Introduces CDC implementation for Citus using logical replication (#6623, #6810, #6827)
-
Adds support for
MERGE
command on co-located distributed tables joined on distribution column (#6696, #6733) -
Adds the view
citus_stat_tenants
that monitor statistics on tenant usages (#6725) -
Adds the GUC
citus.max_background_task_executors_per_node
to control number of background task executors involving a node (#6771) -
Allows parallel shard moves in background rebalancer (#6756)
-
Introduces the GUC
citus.metadata_sync_mode
that introduces nontransactional mode for metadata sync (#6728, #6889) -
Propagates CREATE/ALTER/DROP PUBLICATION statements for distributed tables (#6776)
-
Adds the GUC
citus.enable_non_colocated_router_query_pushdown
to ensure generating a consistent distributed plan for the queries that reference non-colocated distributed tables when set to "false" (#6793) -
Checks if all moves are able to be done via logical replication for rebalancer (#6754)
-
Correctly reports shard size in
citus_shards
view (#6748) -
Fixes a bug in shard copy operations (#6721)
-
Fixes a bug that prevents enforcing identity column restrictions on worker nodes (#6738)
-
Fixes a bug with
INSERT .. SELECT
queries with identity columns (#6802) -
Fixes an issue that caused some queries with custom aggregates to fail (#6805)
-
Fixes an issue when
citus_set_coordinator_host
is called more than once (#6837) -
Fixes an uninitialized memory access in shard split API (#6845)
-
Fixes memory leak and max allocation block errors during metadata syncing (#6728)
-
Fixes memory leak in
undistribute_table
(#6693) -
Fixes memory leak in
alter_distributed_table
(#6726) -
Fixes memory leak in
create_distributed_table
(#6722) -
Fixes memory leak issue with query results that returns single row (#6724)
-
Improves rebalancer when shard groups have placement count less than worker count (#6739)
-
Makes sure to stop maintenance daemon when dropping a database even without Citus extension (#6688)
-
Prevents using
alter_distributed_table
andundistribute_table
UDFs when a table has identity columns (#6738) -
Prevents using identity columns on data types other than
bigint
on distributed tables (#6738)
-
Correctly reports shard size in
citus_shards
view (#6748) -
Fixes a bug in shard copy operations (#6721)
-
Fixes a bug with
INSERT .. SELECT
queries with identity columns (#6802) -
Fixes an uninitialized memory access in shard split API (#6845)
-
Fixes compilation for PG13.10 and PG14.7 (#6711)
-
Fixes memory leak in
alter_distributed_table
(#6726) -
Fixes memory leak issue with query results that returns single row (#6724)
-
Prevents using
alter_distributed_table
andundistribute_table
UDFs when a table has identity columns (#6738) -
Prevents using identity columns on data types other than
bigint
on distributed tables (#6738)
-
Correctly reports shard size in
citus_shards
view (#6748) -
Fixes a bug in shard copy operations (#6721)
-
Fixes a bug that breaks pg upgrades if the user has a columnar table (#6624)
-
Fixes a bug that causes background rebalancer to fail when a reference table doesn't have a primary key (#6682)
-
Fixes a regression in allowed foreign keys on distributed tables (#6550)
-
Fixes a use-after-free bug in connection management (#6685)
-
Fixes an unexpected foreign table error by disallowing to drop the
table_name
option (#6669) -
Fixes an uninitialized memory access in shard split API (#6845)
-
Fixes compilation for PG13.10 and PG14.7 (#6711)
-
Fixes crash that happens when trying to replicate a reference table that is actually dropped (#6595)
-
Fixes memory leak issue with query results that returns single row (#6724)
-
Fixes the modifiers for subscription and role creation (#6603)
-
Makes sure to quote all identifiers used for logical replication to prevent potential issues (#6604)
-
Makes sure to skip foreign key validations at the end of shard moves (#6640)
-
Correctly reports shard size in
citus_shards
view (#6748) -
Fixes a bug that breaks pg upgrades if the user has a columnar table (#6624)
-
Fixes an unexpected foreign table error by disallowing to drop the
table_name
option (#6669) -
Fixes compilation warning on PG13 + OpenSSL 3.0 (#6038, #6502)
-
Fixes crash that happens when trying to replicate a reference table that is actually dropped (#6595)
-
Fixes memory leak issue with query results that returns single row (#6724)
-
Fixes the modifiers for subscription and role creation (#6603)
-
Fixes two potential dangling pointer issues (#6504, #6507)
-
Makes sure to quote all identifiers used for logical replication to prevent potential issues (#6604)
-
Correctly reports shard size in
citus_shards
view (#6748) -
Fixes a bug in
ALTER EXTENSION citus UPDATE
(#6383) -
Fixes a bug that breaks pg upgrades if the user has a columnar table (#6624)
-
Fixes a bug that prevents retaining columnar table options after a table-rewrite (#6337)
-
Fixes memory leak issue with query results that returns single row (#6724)
-
Raises memory limits in columnar from 256MB to 1GB for reads and writes (#6419)
-
Fixes a crash that occurs when the aggregate that cannot be pushed-down returns empty result from a worker (#5679)
-
Fixes columnar freezing/wraparound bug (#5962)
-
Fixes memory leak issue with query results that returns single row (#6724)
-
Prevents alter table functions from dropping extensions (#5974)
-
Fixes a bug that could break
DROP SCHEMA/EXTENSON
commands when there is a columnar table (#5458) -
Fixes a crash that occurs when the aggregate that cannot be pushed-down returns empty result from a worker (#5679)
-
Fixes columnar freezing/wraparound bug (#5962)
-
Fixes memory leak issue with query results that returns single row (#6724)
-
Prevents alter table functions from dropping extensions (#5974)
-
Fixes a crash that occurs when the aggregate that cannot be pushed-down returns empty result from a worker (#5679)
-
Fixes memory leak issue with query results that returns single row (#6724)
-
Prevents alter table functions from dropping extensions (#5974)
-
Adds support for outer joins with reference tables / complex subquery-CTEs in the outer side of the join (e.g., <reference table> LEFT JOIN <distributed table>)
-
Adds support for creating
PRIMARY KEY
s andUNIQUE
/EXCLUSION
/CHECK
/FOREIGN KEY
constraints viaALTER TABLE
command without providing a constraint name -
Adds support for using identity columns on Citus tables
-
Adds support for
MERGE
command on local tables -
Adds
citus_job_list()
,citus_job_status()
andcitus_rebalance_status()
UDFs that allow monitoring rebalancer progress -
Adds
citus_task_wait()
UDF to wait on desired task status -
Adds
source_lsn
,target_lsn
andstatus
fields intoget_rebalance_progress()
-
Introduces
citus_copy_shard_placement()
UDF with node id -
Introduces
citus_move_shard_placement()
UDF with node id -
Propagates
BEGIN
properties to worker nodes -
Propagates
DROP OWNED BY
to worker nodes -
Deprecates
citus.replicate_reference_tables_on_activate
and makes it alwaysoff
-
Drops GUC
citus.defer_drop_after_shard_move
-
Drops GUC
citus.defer_drop_after_shard_split
-
Drops
SHARD_STATE_TO_DELETE
state and uses the cleanup records instead -
Allows
citus_update_node()
to work with nodes from different clusters -
Adds signal handlers for queue monitor to gracefully shutdown, cancel and to see config changes
-
Defers cleanup after a failure in shard move or split
-
Extends cleanup process for replication artifacts
-
Improves a query that terminates compelling backends from
citus_update_node()
-
Includes Citus global pid in all internal
application_name
s -
Avoids leaking
search_path
to workers when executing DDL commands -
Fixes
alter_table_set_access_method error()
for views -
Fixes
citus_drain_node()
to allow draining the specified worker only -
Fixes a bug in global pid assignment for connections opened by rebalancer internally
-
Fixes a bug that causes background rebalancer to fail when a reference table doesn't have a primary key
-
Fixes a bug that might cause failing to query the views based on tables that have renamed columns
-
Fixes a bug that might cause incorrectly planning the sublinks in query tree
-
Fixes a floating point exception during
create_distributed_table_concurrently()
-
Fixes a rebalancer failure due to integer overflow in subscription and role creation
-
Fixes a regression in allowed foreign keys on distributed tables
-
Fixes a use-after-free bug in connection management
-
Fixes an unexpected foreign table error by disallowing to drop the table_name option
-
Fixes an uninitialized memory access in
create_distributed_function()
-
Fixes crash that happens when trying to replicate a reference table that is actually dropped
-
Make sure to cleanup the shard on the target node in case of a failed/aborted shard move
-
Makes sure to create replication artifacts with unique names
-
Makes sure to disallow triggers that depend on extensions
-
Makes sure to quote all identifiers used for logical replication to prevent potential issues
-
Makes sure to skip foreign key validations at the end of shard moves
-
Prevents crashes on
UPDATE
with certainRETURNING
clauses -
Propagates column aliases in the shard-level commands
-
Fixes two potential dangling pointer issues
-
Fixes compilation warning on PG13 + OpenSSL 3.0
-
Adds the GUC
citus.allow_unsafe_constraints
to allow unique/exclusion/ primary key constraints without distribution column -
Allows
citus_internal
application_name
with additional suffix -
Disallows having
ON DELETE/UPDATE SET DEFAULT
actions on columns that default to sequences -
Fixes a bug in
ALTER EXTENSION citus UPDATE
-
Fixes a bug that causes a crash with empty/null password
-
Fixes a bug that causes not retaining trigger enable/disable settings when re-creating them on shards
-
Fixes a bug that might cause inserting incorrect
DEFAULT
values when applying foreign key actions -
Fixes a bug that prevents retaining columnar table options after a table-rewrite
-
Fixes a bug that prevents setting colocation group of a partitioned distributed table to
none
-
Fixes an issue that can cause logical reference table replication to fail
-
Raises memory limits in columnar from 256MB to 1GB for reads and writes
-
Fixes an upgrade problem for
worker_fetch_foreign_file
when upgrade path starts from 8.3 up to 11.1 -
Fixes an upgrade problem for
worker_repartition_cleanup
when upgrade path starts from 9.1 up to 11.1
-
Adds support for PostgreSQL 15.0
-
Fixes a bug in
ALTER EXTENSION citus UPDATE
-
Fixes a bug that causes a crash with empty/null password
-
Fixes a bug that causes not retaining trigger enable/disable settings when re-creating them on shards
-
Fixes a bug that prevents retaining columnar table options after a table-rewrite
-
Raises memory limits in columnar from 256MB to 1GB for reads and writes
-
Adds support for PostgreSQL 15rc1
-
Disallows having
ON DELETE/UPDATE SET DEFAULT
actions on columns that default to sequences -
Fixes a bug that might cause inserting incorrect
DEFAULT
values when applying foreign key actions -
Fixes a performance issue related to shard-moves by creating replica identities before copying shards
-
Improves logging during shard-splits and resource cleanup
-
Makes sure to reuse connections for shard-splits and logical replication
-
Makes sure to try dropping replication slots a few more times after a failure at the end of the shard-split
- Fixes a bug that prevents
create_distributed_table_concurrently()
working on an empty node
-
Adds support for PostgreSQL 15beta4
-
Adds ability to run shard rebalancer in the background
-
Adds
create_distributed_table_concurrently()
UDF to distribute tables without interrupting the application -
Adds
citus_split_shard_by_split_points()
UDF that allows splitting a shard to specified set of nodes without blocking writes and based on given split points -
Adds support for non-blocking tenant isolation
-
Adds support for isolation tenants that use partitioned tables or columnar tables
-
Separates columnar table access method into a separate logical extension
-
Adds support for online replication in
replicate_reference_tables()
-
Improves performance of blocking shard moves
-
Improves non-blocking shard moves with a faster custom copy logic
-
Creates all foreign keys quickly at the end of a shard move
-
Limits
get_rebalance_progress()
to show shards in moving state -
Makes
citus_move_shard_placement()
idempotent if shard already exists on target node -
Shows
citus_copy_shard_placement()
progress inget_rebalance_progres()
-
Supports changing CPU priorities for backends and shard moves
-
Adds the GUC
citus.allow_unsafe_constraints
to allow unique/exclusion/ primary key constraints without distribution column -
Introduces GUC
citus.skip_constraint_validation
-
Introduces
citus_locks
view -
Improves
citus_tables
view by showing local tables added to metadata -
Improves columnar table access method by moving old catalog tables into an internal schema and introduces more secure & informative views based on them
-
Adds support for
GRANT/REVOKE
on aggregates -
Adds support for
NULLS NOT DISTINCT
clauses for indexes for PG15+ -
Adds support for setting relation options for columnar tables using
ALTER TABLE
-
Adds support for unlogged distributed sequences
-
Removes
do_repair
option fromcitus_copy_shard_placement()
-
Removes deprecated re-partitioning functions like
worker_hash_partition_table()
-
Drops support for isolation tenants that use replicated tables
-
Checks existence of the shards before insert, delete, and update
-
Hides tables owned by extensions from
citus_tables
andcitus_shards
-
Propagates
VACUUM
andANALYZE
to worker nodes -
Makes non-partitioned table size calculation quicker
-
Improves
create_distributed_table()
by creating new colocation entries when usingcolocate_with => 'none'
-
Ensures that
SELECT .. FOR UPDATE
opens a transaction block when used in a function call -
Prevents a segfault by disallowing usage of SQL functions referencing to a distributed table
-
Prevents creating a new colocation entry when replicating reference tables
-
Fixes a bug in query escaping in
undistribute_table()
andalter_distributed_table()
-
Fixes a bug preventing the usage of
isolate_tenant_to_new_shard()
with text column -
Fixes a bug that may cause
GRANT
to propagate withinCREATE EXTENSION
-
Fixes a bug that causes incorrectly marking
metadatasynced
flag for coordinator -
Fixes a bug that may prevent Citus from creating function in transaction block properly
-
Fixes a bug that prevents promoting read-replicas as primaries
-
Fixes a bug that prevents setting colocation group of a partitioned distributed table to
none
-
Fixes a bug that prevents using
AUTO
option forVACUUM (INDEX_CLEANUP)
operation -
Fixes a segfault in
citus_copy_shard_placement()
-
Fixes an issue that can cause logical reference table replication to fail
-
Fixes schema name qualification for
RENAME SEQUENCE
statement -
Fixes several small memory leaks
-
Fixes the transaction timestamp column of the
get_current_transaction_id()
on coordinator -
Maps any unused parameters to a generic type in prepared statements
-
Fixes compilation warning caused by latest upgrade script changes
-
Fixes compilation warning on PG13 + OpenSSL 3.0
-
Fixes a bug that could cause failures in
CREATE ROLE
statement -
Fixes a bug that could cause failures in
create_distributed_table
-
Fixes a bug that prevents distributing tables that depend on sequences
-
Fixes reference table lock contention
-
Fixes upgrade paths for 11.0
-
Fixes a bug that could cause failures in
INSERT INTO .. SELECT
-
Fixes a bug that could cause leaking files when materialized views are refreshed
-
Fixes an unexpected error for foreign tables when upgrading Postgres
-
Fixes columnar freezing/wraparound bug
-
Fixes reference table lock contention
-
Prevents alter table functions from dropping extensions
-
Avoids possible information leakage about existing users
-
Allows using
WITH HOLD
cursors with parameters -
Fixes a bug that could cause failures in
INSERT INTO .. SELECT
-
Fixes a bug that prevents pushing down
IN
expressions when using columnar custom scan -
Fixes a concurrency bug between creating a co-located distributed table and shard moves
-
Fixes a crash that can happen due to catalog read in
shmem_exit
-
Fixes an unexpected error caused by constraints when moving shards
-
Fixes an unexpected error for foreign tables when upgrading Postgres
-
Prevents adding local table into metadata if there is a view with circular dependencies on it
-
Reduces memory consumption of index name fix for partitioned tables
- Fixes a bug that prevents promoting read-replicas as primaries
-
Fixes a bug that prevents adding local tables with materialized views to Citus metadata
-
Fixes a bug that prevents using
COMPRESSION
andCONSTRAINT
on a column -
Fixes upgrades to Citus 11 when there are no nodes in the metadata
-
Drops support for PostgreSQL 12
-
Open sources enterprise features, see the rest of changelog items
-
Turns metadata syncing on by default
-
Introduces
citus_finish_citus_upgrade()
procedure which is necessary to upgrade from earlier versions -
Open sources non-blocking shard moves/shard rebalancer (
citus.logical_replication_timeout
) -
Open sources propagation of
CREATE/DROP/ALTER ROLE
statements -
Open sources propagation of
GRANT
statements -
Open sources propagation of
CLUSTER
statements -
Open sources propagation of
ALTER DATABASE ... OWNER TO ...
-
Open sources optimization for
COPY
when loadingJSON
to avoid double parsing of theJSON
object (citus.skip_jsonb_validation_in_copy
) -
Open sources support for row level security
-
Open sources support for
pg_dist_authinfo
, which allows storing different authentication options for different users, e.g. you can store passwords or certificates here. -
Open sources support for
pg_dist_poolinfo
, which allows using connection poolers in between coordinator and workers -
Open sources tracking distributed query execution times using citus_stat_statements (
citus.stat_statements_max
,citus.stat_statements_purge_interval
,citus.stat_statements_track
). This is disabled by default. -
Open sources tenant_isolation
-
Open sources support for
sslkey
andsslcert
incitus.node_conninfo
-
Adds
citus.max_client_connections
GUC to limit non-Citus connections -
Allows locally creating objects having a dependency that cannot be distributed
-
Distributes aggregates with
CREATE AGGREGATE
command -
Distributes functions with
CREATE FUNCTION
command -
Adds
citus.create_object_propagation
GUC to control DDL creation behaviour in transactions -
Hides shards based on
application_name
prefix -
Prevents specifying
application_name
viacitus.node_conninfo
-
Starts identifying rebalancer backends by
application_name=citus_rebalancer
-
Starts identifying internal backends by
application_name=citus_internal
-
Adds
citus.enable_unsafe_triggers
flag to enable unsafe triggers on distributed tables -
Adds
fix_partition_shard_index_names
UDF to fix currently broken names -
Adds propagation for foreign server commands
-
Adds propagation of
DOMAIN
objects -
Adds propagation of
TEXT SEARCH CONFIGURATION
objects -
Adds propagation of
TEXT SEARCH DICTIONARY
objects -
Adds support for
ALTER FUNCTION ... SUPPORT ...
commands -
Adds support for
CREATE SCHEMA AUTHORIZATION
statements without schema name -
Adds support for
CREATE/DROP/ALTER VIEW
commands -
Adds support for
TRUNCATE
for foreign tables -
Adds support for adding local tables to metadata using
citus_add_local_table_to_metadata()
UDF -
Adds support for adding partitioned local tables to Citus metadata
-
Adds support for automatic binary encoding in re-partition joins when possible
-
Adds support for foreign tables in MX
-
Adds support for operator class parameters in indexes
-
Adds support for re-partition joins in transaction blocks
-
Adds support for re-partition joins on followers
-
Adds support for shard replication > 1 hash distributed tables on Citus MX
-
Adds support for
LOCK
commands on distributed tables from worker nodes -
Adds support for
TABLESAMPLE
-
Adds support for propagating views when syncing Citus table metadata
-
Improves handling of
IN
,OUT
andINOUT
parameters for functions -
Introduces
citus_backend_gpid()
UDF to get global pid of the current backend -
Introduces
citus_check_cluster_node_health
UDF to check cluster connectivity -
Introduces
citus_check_connection_to_node
UDF to check node connectivity -
Introduces
citus_coordinator_nodeid
UDF to find the node id of the coordinator node -
Introduces
citus_stat_activity
view and dropscitus_worker_stat_activity
UDF -
Introduces
citus.use_citus_managed_tables
GUC to add local tables to Citus metadata automatically -
Introduces a new flag
force_delegation
increate_distributed_function()
-
Introduces
run_command_on_coordinator
UDF -
Introduces
synchronous
option tocitus_disable_node()
UDF -
Introduces
citus_is_coordinator
UDF to check whether a node is the coordinator -
Allows adding a unique constraint with an index
-
Allows
create_distributed_function()
on a function owned by an extension -
Allows creating distributed tables in sequential mode
-
Allows disabling nodes when multiple failures happen
-
Allows
lock_table_if_exits
to be called outside of a transaction blocks -
Adds support for pushing procedures with
OUT
arguments down to the worker nodes -
Overrides
pg_cancel_backend()
andpg_terminate_backend()
to run with global pid -
Delegates function calls of the form
SELECT .. FROM func()
-
Adds propagation of
CREATE SCHEMA .. GRANT ON SCHEMA ..
commands -
Propagates
pg_dist_object
to worker nodes -
Adds propagation of
SCHEMA
operations -
Adds missing version-mismatch checks for columnar tables
-
Adds missing version-mismatch checks for internal functions
-
citus_shard_indexes_on_worker
shows all local shard indexes regardless ofsearch_path
-
citus_shards_on_worker
shows all local shards regardless ofsearch_path
-
Enables distributed execution from
run_command_on_*
functions -
Deprecates inactive shard state, never marks any placement inactive
-
Disables distributed & reference foreign tables
-
Prevents propagating objects having a circular dependency
-
Prevents propagating objects having a dependency to an object with unsupported type
-
Deprecates
master_get_table_metadata
UDF -
Disallows remote execution from queries on shards
-
Drops
citus.enable_cte_inlining
GUC -
Drops
citus.single_shard_commit_protocol
GUC, defaults to 2PC -
Drops support for
citus.multi_shard_commit_protocol
, always use 2PC -
Avoids unnecessary errors for
ALTER STATISTICS IF EXISTS
when the statistics does not exist -
Fixes a bug that prevents dropping/altering indexes
-
Fixes a bug that prevents non-client backends from accessing shards
-
Fixes columnar freezing/wraparound bug
-
Fixes
invalid read of size 1
memory error withcitus_add_node
-
Fixes schema name qualification for
ALTER/DROP SEQUENCE
-
Fixes schema name qualification for
ALTER/DROP STATISTICS
-
Fixes schema name qualification for
CREATE STATISTICS
-
Fixes a bug that causes columnar storage pages to have zero LSN
-
Fixes a bug that causes issues while create dependencies from multiple sessions
-
Fixes a bug that causes reading columnar metapage as all-zeros when writing to a columnar table
-
Fixes a bug that could break
DROP SCHEMA/EXTENSON
commands when there is a columnar table -
Fixes a bug that could break pg upgrades due to missing
pg_depend
records for columnar table access method -
Fixes a bug that could cause
CREATE INDEX
to fail for expressions when using customsearch_path
-
Fixes a bug that could cause
worker_save_query_explain_analyze
to fail on custom types -
Fixes a bug that could cause failed re-partition joins to leak result tables
-
Fixes a bug that could cause prerequisite columnar table access method objects being not created during pg upgrades
-
Fixes a bug that could cause re-partition joins involving local shards to fail
-
Fixes a bug that could cause false positive distributed deadlocks due to local execution
-
Fixes a bug that could cause leaking files when materialized views are refreshed
-
Fixes a bug that could cause unqualified
DROP DOMAIN IF EXISTS
to fail -
Fixes a bug that could cause wrong schema and ownership after
alter_distributed_table
-
Fixes a bug that could cause
EXPLAIN ANALYZE
to fail for prepared statements with custom type -
Fixes a bug that could cause Citus not to create function in transaction block properly
-
Fixes a bug that could cause returning invalid JSON when running
EXPLAIN ANALYZE
with subplans -
Fixes a bug that limits usage of sequences in non-int columns
-
Fixes a bug that prevents
DROP SCHEMA CASCADE
-
Fixes a build error that happens when
lz4
is not installed -
Fixes a clog lookup failure that could occur when writing to a columnar table
-
Fixes a crash that occurs when the aggregate that cannot be pushed-down returns empty result from a worker
-
Fixes a missing
FROM
clause entry error -
Fixes a possible segfault that could happen when reporting distributed deadlock
-
Fixes an issue that could cause unexpected errors when there is an in-progress write to a columnar table
-
Fixes an unexpected error that occurs due to aborted writes to a columnar table with an index
-
Fixes an unexpected error that occurs when writing to a columnar table created in older version
-
Fixes issue when compiling Citus from source with some compilers
-
Fixes issues on
ATTACH PARTITION
logic -
Fixes naming issues of newly created partitioned indexes
-
Honors
enable_metadata_sync
in node operations -
Improves nested execution checks and adds GUC to control (
citus.allow_nested_distributed_execution
) -
Improves self-deadlock prevention for
CREATE INDEX / REINDEX CONCURRENTLY
commands for builds using PG14 or higher -
Moves
pg_dist_object
topg_catalog
schema -
Parallelizes metadata syncing on node activation
-
Partitions shards to be co-located with the parent shards
-
Prevents Citus table functions from being called on shards
-
Prevents creating distributed functions when there are out of sync nodes
-
Prevents alter table functions from dropping extensions
-
Refrains reading the metadata cache for all tables during upgrade
-
Provides notice message for idempotent
create_distributed_function
calls -
Reinstates optimisation for uniform shard interval ranges
-
Relaxes table ownership check to privileges check while acquiring lock
-
Drops support for
citus.shard_placement_policy
GUC -
Drops
master_append_table_to_shard
UDF -
Drops
master_apply_delete_command
UDF -
Removes copy into new shard logic for append-distributed tables
-
Drops support for distributed
cstore_fdw
tables in favor of Citus columnar table access method -
Removes support for dropping distributed and local indexes in the same statement
-
Replaces
citus.enable_object_propagation
GUC withcitus.enable_metadata_sync
-
Requires superuser for
citus_add_node()
andcitus_activate_node()
UDFs -
Revokes read access to
columnar.chunk
from unprivileged user -
Disallows unsupported lateral subqueries on distributed tables
-
Stops updating shard range in
citus_update_shard_statistics
for append tables
-
Fixes a bug that could cause
worker_save_query_explain_analyze
to fail on custom types -
Fixes a bug that limits usage of sequences in non-integer columns
-
Fixes a crash that occurs when the aggregate that cannot be pushed-down returns empty result from a worker
-
Improves concurrent metadata syncing and metadata changing DDL operations
-
Adds support for operator class parameters in indexes
-
Fixes a bug with distributed functions that have
OUT
parameters or returnTABLE
-
Fixes a build error that happens when
lz4
is not installed -
Improves self-deadlock prevention for
CREATE INDEX
&REINDEX CONCURRENTLY
commands for builds using PG14 or higher -
Fixes a bug that causes commands to fail when
application_name
is set
-
Adds missing version checks for columnar tables
-
Fixes a bug that could break
DROP SCHEMA/EXTENSION
commands when there is a columnar table -
Fixes a build error that happens when
lz4
is not installed -
Fixes a missing
FROM
clause entry error -
Reinstates optimisation for uniform shard interval ranges
-
Fixes a bug that causes commands to fail when
application_name
is set
-
Adds
fix_partition_shard_index_names
udf to fix currently broken partition index names -
Fixes a bug that could break
DROP SCHEMA/EXTENSION
commands when there is a columnar table -
Fixes a bug that could break pg upgrades due to missing
pg_depend
records for columnar table access method -
Fixes a missing
FROM
clause entry error -
Fixes an unexpected error that occurs when writing to a columnar table created in older versions
-
Fixes issue when compiling Citus from source with some compilers
-
Reinstates optimisation for uniform shard interval ranges
-
Relaxes table ownership check to privileges check while acquiring lock
-
Adds missing version checks for columnar tables
-
Fixes a bug that caused
worker_append_table_to_shard
to write as superuser -
Fixes a bug with local cached plans on tables with dropped columns
-
Fixes a missing
FROM
clause entry error -
Fixes a use after free issue that could happen when altering a distributed table
-
Reinstates optimisation for uniform shard interval ranges
- Fixes a release problem in 9.5.9
-
Fixes a bug preventing
INSERT SELECT .. ON CONFLICT
with a constraint name on local shards -
Fixes a bug with local cached plans on tables with dropped columns
-
Fixes a crash in queries with a modifying
CTE
and aSELECT
withoutFROM
-
Fixes a missing
FROM
clause entry error -
Fixes a missing intermediate result when coordinator is in metadata
-
Reinstates optimisation for uniform shard interval ranges
- Adds a configure flag to enforce security
-
Fixes
ALTER TABLE IF EXISTS SET SCHEMA
with non-existing table bug -
Fixes
CREATE INDEX CONCURRENTLY
with no index name on a postgres table bug -
Fixes a bug that could cause crashes with certain compile flags
-
Fixes a crash because of overflow in partition id with certain compile flags
-
Fixes a memory leak in subtransaction memory handling
-
Fixes deparsing for queries with anonymous column references
-
Fixes a bug that causes reading columnar metapage as all-zeros when writing to a columnar table
-
Fixes a bug that could cause prerequisite columnar table access method objects being not created during pg upgrades
-
Fixes a bug that could cause
CREATE INDEX
to fail for expressions when using customsearch_path
-
Fixes an unexpected error that occurs due to aborted writes to a columnar table with an index
-
Adds missing version-mismatch checks for columnar tables
-
Adds missing version-mismatch checks for internal functions
-
Fixes a bug that could cause partition shards being not co-located with parent shards
-
Fixes a bug that prevents pushing down boolean expressions when using columnar custom scan
-
Fixes a clog lookup failure that could occur when writing to a columnar table
-
Fixes an issue that could cause unexpected errors when there is an in-progress write to a columnar table
-
Revokes read access to
columnar.chunk
from unprivileged user
-
Fixes a bug that caused
worker_append_table_to_shard
to write as superuser -
Fixes a crash in shard rebalancer when no distributed tables exist
-
Fixes a use after free issue that could happen when altering a distributed table
-
Fixes a bug that caused
worker_append_table_to_shard
to write as superuser -
Fixes a use after free issue that could happen when altering a distributed table
-
Adds PostgreSQL 14 support
-
Adds hash & btree index support for columnar tables
-
Adds helper UDFs for easy time partition management:
get_missing_time_partition_ranges
,create_time_partitions
, anddrop_old_time_partitions
-
Adds propagation of ALTER SEQUENCE
-
Adds support for ALTER INDEX ATTACH PARTITION
-
Adds support for CREATE INDEX ON ONLY
-
Allows more graceful failovers when replication factor > 1
-
Enables chunk group filtering to work with Params for columnar tables
-
Enables qual push down for joins including columnar tables
-
Enables transferring of data using binary encoding by default on PG14
-
Improves
master_update_table_statistics
and provides distributed deadlock detection -
Includes
data_type
andcache
in sequence definition on worker -
Makes start/stop_metadata_sync_to_node() transactional
-
Makes sure that table exists before updating table statistics
-
Prevents errors with concurrent
citus_update_table_statistics
and DROP table -
Reduces memory usage of columnar table scans by freeing the memory used for last stripe read
-
Shows projected columns for columnar tables in EXPLAIN output
-
Speeds up dropping partitioned tables
-
Synchronizes hasmetadata flag on mx workers
-
Uses current user while syncing metadata
-
Adds a parameter to cleanup metadata when metadata syncing is stopped
-
Fixes a bug about int and smallint sequences on MX
-
Fixes a bug that cause partitions to have wrong distribution key after DROP COLUMN
-
Fixes a bug that caused
worker_append_table_to_shard
to write as superuser -
Fixes a bug that caused
worker_create_or_alter_role
to crash with NULL input -
Fixes a bug that causes pruning incorrect shard of a range distributed table
-
Fixes a bug that may cause crash while aborting transaction
-
Fixes a bug that prevents attaching partitions when colocated foreign key exists
-
Fixes a bug with
nextval('seq_name'::text)
-
Fixes a crash in shard rebalancer when no distributed tables exist
-
Fixes a segfault caused by use after free in when using a cached connection
-
Fixes a UNION pushdown issue
-
Fixes a use after free issue that could happen when altering a distributed table
-
Fixes showing target shard size in the rebalance progress monitor
-
Allows more graceful failovers when replication factor > 1
-
Fixes a bug that causes partitions to have wrong distribution key after
DROP COLUMN
-
Allows more graceful failovers when replication factor > 1
-
Fixes a bug that causes partitions to have wrong distribution key after
DROP COLUMN
-
Improves citus_update_table_statistics and provides distributed deadlock detection
-
Allows more graceful failovers when replication factor > 1
-
Fixes a bug that causes partitions to have wrong distribution key after
DROP COLUMN
-
Improves master_update_table_statistics and provides distributed deadlock detection
-
Allows more graceful failovers when replication factor > 1
-
Improves master_update_table_statistics and provides distributed deadlock detection
-
Improves citus_update_table_statistics and provides distributed deadlock detection
-
Fixes showing target shard size in the rebalance progress monitor
-
Drops support for PostgreSQL 11
-
Adds
shard_count
parameter tocreate_distributed_table
function -
Adds support for
ALTER DATABASE OWNER
-
Adds support for temporary columnar tables
-
Adds support for using sequences as column default values when syncing metadata
-
alter_columnar_table_set
enforces columnar table option constraints -
Continues to remove shards after failure in
DropMarkedShards
-
Deprecates the
citus.replication_model
GUC -
Enables
citus.defer_drop_after_shard_move
by default -
Ensures free disk space before moving a shard
-
Fetches shard size on the fly for the rebalance monitor
-
Ignores old placements when disabling or removing a node
-
Implements
improvement_threshold
at shard rebalancer moves -
Improves orphaned shard cleanup logic
-
Improves performance of
citus_shards
-
Introduces
citus.local_hostname
GUC for connections to the current node -
Makes sure connection is closed after each shard move
-
Makes sure that target node in shard moves is eligible for shard move
-
Optimizes partitioned disk size calculation for shard rebalancer
-
Prevents connection errors by properly terminating connections
-
Prevents inheriting a distributed table
-
Prevents users from dropping & truncating known shards
-
Pushes down
VALUES
clause as long as not in outer part of aJOIN
-
Reduces memory usage for multi-row inserts
-
Reduces memory usage while rebalancing shards
-
Removes length limits around partition names
-
Removes dependencies on the existence of public schema
-
Executor avoids opening extra connections
-
Excludes orphaned shards while finding shard placements
-
Preserves access method of materialized views when undistributing or altering distributed tables
-
Fixes a bug that allowed moving of shards belonging to a reference table
-
Fixes a bug that can cause a crash when DEBUG4 logging is enabled
-
Fixes a bug that causes pruning incorrect shard of a range distributed table
-
Fixes a bug that causes worker_create_or_alter_role to crash with NULL input
-
Fixes a bug where foreign key to reference table was disallowed
-
Fixes a bug with local cached plans on tables with dropped columns
-
Fixes data race in
get_rebalance_progress
-
Fixes
FROM ONLY
queries on partitioned tables -
Fixes an issue that could cause citus_finish_pg_upgrade to fail
-
Fixes error message for local table joins
-
Fixes issues caused by omitting public schema in queries
-
Fixes nested
SELECT
query withUNION
bug -
Fixes null relationName bug at parallel execution
-
Fixes possible segfaults when using Citus in the middle of an upgrade
-
Fixes problems with concurrent calls of
DropMarkedShards
-
Fixes shared dependencies that are not resident in a database
-
Fixes stale hostnames bug in prepared statements after
master_update_node
-
Fixes the relation size bug during rebalancing
-
Fixes two race conditions in the get_rebalance_progress
-
Fixes using 2PC when it might be necessary
-
Introduces
citus.local_hostname
GUC for connections to the current node -
Removes dependencies on the existence of public schema
-
Removes limits around long partition names
-
Fixes a bug that can cause a crash when DEBUG4 logging is enabled
-
Fixes a bug that causes pruning incorrect shard of a range distributed table
-
Fixes an issue that could cause citus_finish_pg_upgrade to fail
-
Fixes FROM ONLY queries on partitioned tables
-
Fixes issues caused by public schema being omitted in queries
-
Fixes problems with concurrent calls of DropMarkedShards
-
Fixes relname null bug when using parallel execution
-
Fixes two race conditions in the get_rebalance_progress
- Fixes minor bug in
citus_prepare_pg_upgrade
that caused it to lose its idempotency
-
Adds a configure flag to enforce security
-
Fixes a bug that causes pruning incorrect shard of a range distributed table
-
Fixes an issue that could cause citus_finish_pg_upgrade to fail
-
Adds a configure flag to enforce security
-
Avoids re-using connections for intermediate results
-
Fixes a bug that causes pruning incorrect shard of a range distributed table
-
Fixes a bug that might cause self-deadlocks when COPY used in TX block
-
Fixes an issue that could cause citus_finish_pg_upgrade to fail
-
Fixes a bug that leads to various issues when a connection is lost
-
Fixes a bug where one could create a foreign key between non-colocated tables
-
Fixes a deadlock during transaction recovery
-
Fixes a memory leak in adaptive executor when query returns many columns
-
Prevents infinite recursion for queries that involve
UNION ALL
belowJOIN
-
Fixes a crash in queries with a modifying
CTE
and aSELECT
withoutFROM
-
Fixes upgrade and downgrade paths for
citus_update_table_statistics
-
Fixes a bug that causes
SELECT
queries to use 2PC unnecessarily -
Fixes a bug that might cause self-deadlocks with
CREATE INDEX
/REINDEX CONCURRENTLY
commands -
Adds
citus.max_cached_connection_lifetime
GUC to set maximum connection lifetime -
Adds
citus.remote_copy_flush_threshold
GUC that controls per-shard memory usages byCOPY
-
Adds
citus_get_active_worker_nodes
UDF to deprecatemaster_get_active_worker_nodes
-
Skips 2PC for readonly connections in a transaction
-
Makes sure that local execution starts coordinated transaction
-
Removes open temporary file warning when cancelling a query with an open tuple store
-
Relaxes the locks when adding an existing node
-
Adds a configure flag to enforce security
-
Fixes a bug due to cross join without target list
-
Fixes a bug with
UNION ALL
on PG 13 -
Fixes a compatibility issue with pg_audit in utility calls
-
Fixes insert query with CTEs/sublinks/subqueries etc
-
Grants
SELECT
permission oncitus_tables
view topublic
-
Grants
SELECT
permission on columnar metadata tables topublic
-
Improves
citus_update_table_statistics
and provides distributed deadlock detection -
Preserves colocation with procedures in
alter_distributed_table
-
Prevents using
alter_columnar_table_set
andalter_columnar_table_reset
on a columnar table not owned by the user -
Removes limits around long table names
- Fixes a compatibility issue with pg_audit in utility calls
- Fixes an issue in creation of
pg_catalog.time_partitions
view
-
Avoids re-using connections for intermediate results
-
Fixes a bug that might cause self-deadlocks when
COPY
used in xact block -
Fixes a crash that occurs when distributing table after dropping foreign key
-
Adds support for per-table option for columnar storage
-
Adds
rebalance_table_shards
to rebalance the shards across the nodes -
Adds
citus_drain_node
to move all shards away from any node -
Enables single-node Citus for production workloads
-
Adds support for local table and distributed table/subquery joins
-
Enables foreign keys between reference tables and local tables (
citus.enable_local_reference_table_foreign_keys
) -
Adds support for co-located/recurring correlated subqueries
-
Adds support for co-located/recurring sublinks in the target list
-
Adds
alter_distributed_table
andalter_table_set_access_method
UDFs -
Adds
alter_old_partitions_set_access_method
UDF to compress old partitions -
Adds cascade option to
undistribute_table
UDF for foreign key connected relations -
Allows distributed table creation immediately after CREATE EXTENSION citus
-
Automatically adds coordinator to the metadata before the first distributed table created
-
Introduces adaptive connection management for local nodes
-
Adds support for local execution in
INSERT..SELECT
commands that perform re-partitioning -
Adds
public.citus_tables
view -
Adds
pg_catalog.citus_shards
,pg_catalog.citus_shards_on_worker
andpg_catalog.citus_shard_indexes_on_worker
views -
Adds
pg_catalog.time_partitions
view for simple (time) partitions and their access methods -
Adds
remove_local_tables_from_metadata
UDF for local tables automatically added to metadata when defining foreign keys with reference tables -
Adds support for
CREATE INDEX
commands without index name on citus tables -
Adds support for
CREATE TABLE ... USING table_access_method
statements -
Propagates
ALTER TABLE .. SET LOGGED/UNLOGGED
statements -
Propagates
ALTER INDEX .. SET STATISTICS
statements -
Propagates
ALTER SCHEMA RENAME
statements -
Propagates
CREATE STATISTICS
statements across workers. -
Propagates
DROP STATISTICS
statements across the workers -
Propagates all types of
ALTER STATISTICS
statements. -
Avoids establishing new connections until the previous ones are finalized
-
Avoids re-using connections for intermediate results
-
Improves performance in some subquery pushdown cases
-
Removes unused
citus.binary_master_copy_format
GUC -
Removes unused
citus.expire_cached_shards
GUC -
Removes unused
citus.large_table_shard_count
GUC -
Removes unused
citus.max_assign_task_batch_size
GUC -
Removes unused
citus.max_running_tasks_per_node
GUC -
Removes unused
citus.max_task_string_size
GUC -
Removes unused
citus.max_tracked_tasks_per_node
GUC -
Removes unused
citus.sslmode
GUC -
Removes unused
citus.task_tracker_delay
GUC -
Removes the word 'master' from Citus UDFs
-
Removes unused UDF
mark_tables_colocated
-
Removes
upgrade_to_reference_table
UDF -
Renames 'master' to 'distributed' for columns of
citus_dist_stat_activity
-
Renames 'master' to 'distributed' for columns of
citus_worker_stat_activity
-
Chooses the default co-location group deterministically
-
Deletes distributed transaction entries when removing a node
-
Drops support for
create_citus_local_table
in favor ofcitus_add_local_table_to_metadata
-
Fixes
EXPLAIN ANALYZE
error when query returns no columns -
Fixes a bug preventing
INSERT SELECT .. ON CONFLICT
with a constraint name on local shards -
Fixes a bug related to correctness of multiple joins
-
Fixes a bug that might cause self-deadlocks when
COPY
used in xact block -
Fixes a bug with partitioned tables that block new partition creation due to wrong constraint names on workers
-
Fixes a crash that occurs when distributing table after dropping foreign key
-
Fixes a crash when adding/dropping foreign keys from reference to local tables added to metadata
-
Fixes an unexpected error when executing
CREATE TABLE IF NOT EXISTS PARTITION OF
commands -
Fixes deadlock issue for
CREATE INDEX
in single node -
Fixes distributed deadlock detection being blocked by metadata sync
-
Fixes handling indexes when adding local table to metadata
-
Fixes
undistribute_table
when table has column withGENERATED ALWAYS AS STORED
expressions -
Improves concurrent index creation failure message
-
Prevents empty placement creation in the coordinator when executing
master_create_empty_shard()
-
Fixes distributed deadlock detection being blocked by metadata sync
-
Prevents segfaults when SAVEPOINT handling cannot recover from connection failures
-
Fixes possible issues that might occur with single shard distributed tables
-
Fixes a bug that could cause router queries with local tables to be pushed down
-
Fixes a segfault in connection management due to invalid connection hash entries
-
Fixes possible issues that might occur with single shard distributed tables
-
Enables PostgreSQL's parallel queries on EXPLAIN ANALYZE
-
Fixes a bug that could cause excessive memory consumption when a partition is created
-
Fixes a bug that triggers subplan executions unnecessarily with cursors
-
Fixes a segfault in connection management due to invalid connection hash entries
-
Enables PostgreSQL's parallel queries on EXPLAIN ANALYZE
-
Fixes a bug that triggers subplan executions unnecessarily with cursors
-
Adds support for PostgreSQL 13
-
Removes the task-tracker executor
-
Introduces citus local tables
-
Introduces
undistribute_table
UDF to convert tables back to postgres tables -
Adds support for
EXPLAIN (ANALYZE) EXECUTE
andEXPLAIN EXECUTE
-
Adds support for
EXPLAIN (ANALYZE, WAL)
for PG13 -
Sorts the output of
EXPLAIN (ANALYZE)
by execution duration. -
Adds support for CREATE TABLE ... USING table_access_method
-
Adds support for
WITH TIES
option in SELECT and INSERT SELECT queries -
Avoids taking multi-shard locks on workers
-
Enforces
citus.max_shared_pool_size
config in COPY queries -
Enables custom aggregates with multiple parameters to be executed on workers
-
Enforces
citus.max_intermediate_result_size
in local execution -
Improves cost estimation of INSERT SELECT plans
-
Introduces delegation of procedures that read from reference tables
-
Prevents pull-push execution for simple pushdownable subqueries
-
Improves error message when creating a foreign key to a local table
-
Makes
citus_prepare_pg_upgrade
idempotent by dropping transition tables -
Disallows
ON TRUE
outer joins with reference & distributed tables when reference table is outer relation to avoid incorrect results -
Disallows field indirection in INSERT/UPDATE queries to avoid incorrect results
-
Disallows volatile functions in UPDATE subqueries to avoid incorrect results
-
Fixes CREATE INDEX CONCURRENTLY crash with local execution
-
Fixes
citus_finish_pg_upgrade
to drop all backup tables -
Fixes a bug that cause failures when
RECURSIVE VIEW
joined reference table -
Fixes DROP SEQUENCE failures when metadata syncing is enabled
-
Fixes a bug that caused CREATE TABLE with CHECK constraint to fail
-
Fixes a bug that could cause VACUUM to deadlock
-
Fixes master_update_node failure when no background worker slots are available
-
Fixes a bug that caused replica identity to not be propagated on shard repair
-
Fixes a bug that could cause crashes after connection timeouts
-
Fixes a bug that could cause crashes with certain compile flags
-
Fixes a bug that could cause deadlocks on CREATE INDEX
-
Fixes a bug with genetic query optimization in outer joins
-
Fixes a crash when aggregating empty tables
-
Fixes a crash with inserting domain constrained composite types
-
Fixes a crash with multi-row & router INSERT's in local execution
-
Fixes a possibility of doing temporary file cleanup more than once
-
Fixes incorrect setting of join related fields
-
Fixes memory issues around deparsing index commands
-
Fixes reference table access tracking for sequential execution
-
Fixes removal of a single node with only reference tables
-
Fixes sending commands to coordinator when it is added as a worker
-
Fixes write queries with const expressions and COLLATE in various places
-
Fixes wrong cancellation message about distributed deadlock
-
Fixes a bug that could lead to multiple maintenance daemons
-
Fixes an issue preventing views in reference table modifications
-
Fixes EXPLAIN ANALYZE output truncation
-
Fixes a deadlock during transaction recovery
-
Improves COPY by honoring max_adaptive_executor_pool_size config
-
Adds support for insert into local table select from distributed table
-
Adds support to partially push down tdigest aggregates
-
Adds support for receiving binary encoded results from workers using citus.enable_binary_protocol
-
Enables joins between local tables and CTEs
-
Adds showing query text in EXPLAIN output when explain verbose is true
-
Adds support for showing CTE statistics in EXPLAIN ANALYZE
-
Adds support for showing amount of data received in EXPLAIN ANALYZE
-
Introduces downgrade paths in migration scripts
-
Avoids returning incorrect results when changing roles in a transaction
-
Fixes
ALTER TABLE IF EXISTS SET SCHEMA
with non-existing table bug -
Fixes
CREATE INDEX CONCURRENTLY
with no index name on a postgres table bug -
Fixes a bug that could cause crashes with certain compile flags
-
Fixes a bug with lists of configuration values in ALTER ROLE SET statements
-
Fixes a bug that occurs when coordinator is added as a worker node
-
Fixes a crash because of overflow in partition id with certain compile flags
-
Fixes a crash that may happen if no worker nodes are added
-
Fixes a crash that occurs when inserting implicitly coerced constants
-
Fixes a crash when aggregating empty tables
-
Fixes a memory leak in subtransaction memory handling
-
Fixes crash when using rollback to savepoint after cancellation of DML
-
Fixes deparsing for queries with anonymous column references
-
Fixes distribution of composite types failing to include typemods
-
Fixes explain analyze on adaptive executor repartitions
-
Fixes possible error throwing in abort handle
-
Fixes segfault when evaluating func calls with default params on coordinator
-
Fixes several EXPLAIN ANALYZE issues
-
Fixes write queries with const expressions and COLLATE in various places
-
Fixes wrong cancellation message about distributed deadlocks
-
Reports correct INSERT/SELECT method in EXPLAIN
-
Disallows triggers on citus tables
-
Fixes
ALTER TABLE IF EXISTS SET SCHEMA
with non-existing table bug -
Fixes
CREATE INDEX CONCURRENTLY
with no index name on a postgres table bug -
Fixes a crash because of overflow in partition id with certain compile flags
-
Fixes a bug that could cause crashes with certain compile flags
-
Fixes a bug with lists of configuration values in ALTER ROLE SET statements
-
Fixes deparsing for queries with anonymous column references
- Fixes a memory leak in subtransaction memory handling
- Fixes a version bump issue in 9.3.1
- Fixes a version bump issue in 9.2.5
-
Adds support to partially push down tdigest aggregates
-
Fixes a crash that occurs when inserting implicitly coerced constants
-
Adds support to partially push down tdigest aggregates
-
Fixes an issue with distributing tables having generated cols not at the end
-
Adds
max_shared_pool_size
to control number of connections across sessions -
Adds support for window functions on coordinator
-
Improves shard pruning logic to understand OR-conditions
-
Prevents using an extra connection for intermediate result multi-casts
-
Adds propagation of
ALTER ROLE .. SET
statements -
Adds
update_distributed_table_colocation
UDF to update colocation of tables -
Introduces a UDF to truncate local data after distributing a table
-
Adds support for creating temp schemas in parallel
-
Adds support for evaluation of
nextval
in the target list on coordinator -
Adds support for local execution of
COPY/TRUNCATE/DROP/DDL
commands -
Adds support for local execution of shard creation
-
Uses local execution in a transaction block
-
Adds support for querying distributed table sizes concurrently
-
Allows
master_copy_shard_placement
to replicate placements to new nodes -
Allows table type to be used in target list
-
Avoids having multiple maintenance daemons active for a single database
-
Defers reference table replication to shard creation time
-
Enables joins between local tables and reference tables in transaction blocks
-
Ignores pruned target list entries in coordinator plan
-
Improves
SIGTERM
handling of maintenance daemon -
Increases the default of
citus.node_connection_timeout
to 30 seconds -
Fixes a bug that occurs when creating remote tasks in local execution
-
Fixes a bug that causes some DML queries containing aggregates to fail
-
Fixes a bug that could cause failures in queries with subqueries or CTEs
-
Fixes a bug that may cause some connection failures to throw errors
-
Fixes a bug which caused queries with SRFs and function evalution to fail
-
Fixes a bug with generated columns when executing
COPY dist_table TO file
-
Fixes a crash when using non-constant limit clauses
-
Fixes a failure when composite types used in prepared statements
-
Fixes a possible segfault when dropping dist. table in a transaction block
-
Fixes a possible segfault when non-pushdownable aggs are solely used in HAVING
-
Fixes a segfault when executing queries using
GROUPING
-
Fixes an error when using
LEFT JOIN with GROUP BY
on primary key -
Fixes an issue with distributing tables having generated cols not at the end
-
Fixes automatic SSL permission issue when using "initdb --allow-group-access"
-
Fixes errors which could occur when subqueries are parameters to aggregates
-
Fixes possible issues by invalidating the plan cache in
master_update_node
-
Fixes timing issues which could be caused by changing system clock
- Fixes a release problem in 9.2.3
-
Do not use C functions that have been banned by Microsoft
-
Fixes a bug that causes wrong results with complex outer joins
-
Fixes issues found using static analysis
-
Fixes left join shard pruning in pushdown planner
-
Fixes possibility for segmentation fault in internal aggregate functions
-
Fixes possible segfault when non pushdownable aggregates are used in
HAVING
-
Improves correctness of planning subqueries in
HAVING
-
Prevents using old connections for security if
citus.node_conninfo
changed -
Uses Microsoft approved cipher string for default TLS setup
-
Fixes build errors on EL/OL 6 based distros
-
Fixes a bug that caused maintenance daemon to fail on standby nodes
-
Disallows distributed function creation when replication_model is
statement
-
Fixes a bug that caused some prepared stmts with function calls to fail
-
Fixes a bug that caused some prepared stmts with composite types to fail
-
Fixes a bug that caused missing subplan results in workers
-
Improves performance of re-partition joins
- Fixes a bug that could cause crashes if distribution key is NULL
-
Adds support for
INSERT...SELECT
queries with re-partitioning -
Adds
citus.coordinator_aggregation_strategy
to support more aggregates -
Adds caching of local plans on shards for Citus MX
-
Adds compatibility support for dist. object infrastructure from old versions
-
Adds defering shard-pruning for fast-path router queries to execution
-
Adds propagation of
GRANT ... ON SCHEMA
queries -
Adds support for CTE pushdown via CTE inlining in distributed planning
-
Adds support for
ALTER TABLE ... SET SCHEMA
propagation. -
Adds support for
DROP ROUTINE
&ALTER ROUTINE
commands -
Adds support for any inner join on a reference table
-
Changes
citus.log_remote_commands
level toNOTICE
-
Disallows marking ref. table shards unhealthy in the presence of savepoints
-
Disallows placing new shards with shards in TO_DELETE state
-
Enables local execution of queries that do not need any data access
-
Fixes Makefile trying to cleanup PG directory during install
-
Fixes a bug causing errors when planning a query with multiple subqueries
-
Fixes a possible deadlock that could happen during shard moves
-
Fixes a problem when adding a new node due to tables referenced in func body
-
Fixes an issue that could cause joins with reference tables to be slow
-
Fixes cached metadata for shard is inconsistent issue
-
Fixes inserting multiple composite types as partition key in VALUES
-
Fixes unnecessary repartition on joins with more than 4 tables
-
Prevents wrong results for replicated partitioned tables after failure
-
Restricts LIMIT approximation for non-commutative aggregates
- Fixes a bug that prevents installation from source
-
Fixes a bug causing SQL-executing UDFs to crash when passing in DDL
-
Fixes a bug that caused column_to_column_name to crash for invalid input
-
Fixes a bug that caused inserts into local tables w/ dist. subqueries to crash
-
Fixes a bug that caused some noop DML statements to fail
-
Fixes a bug that prevents dropping reference table columns
-
Fixes a crash in IN (.., NULL) queries
-
Fixes a crash when calling a distributed function from PL/pgSQL
-
Fixes an issue that caused CTEs to sometimes leak connections
-
Fixes strange errors in DML with unreachable sublinks
-
Prevents statements in SQL functions to run outside of a transaction
-
Adds extensions to distributed object propagation infrastructure
-
Adds support for ALTER ROLE propagation
-
Adds support for aggregates in create_distributed_function
-
Adds support for expressions in reference joins
-
Adds support for returning RECORD in multi-shard queries
-
Adds support for simple IN subqueries on unique cols in repartition joins
-
Adds support for subqueries in HAVING clauses
-
Automatically distributes unary aggs w/ combinefunc and non-internal stype
-
Disallows distributed func creation when replication_model is 'statement'
-
Drops support for deprecated real-time and router executors
-
Fixes a bug in local execution that could cause missing rows in RETURNING
-
Fixes a bug that caused maintenance daemon to fail on standby nodes
-
Fixes a bug that caused other CREATE EXTENSION commands to take longer
-
Fixes a bug that prevented REFRESH MATERIALIZED VIEW
-
Fixes a bug when view is used in modify statements
-
Fixes a memory leak in adaptive executor when query returns many columns
-
Fixes underflow init of default values in worker extended op node creation
-
Fixes potential segfault in standard_planner inlining functions
-
Fixes an issue that caused failures in RHEL 6 builds
-
Fixes queries with repartition joins and group by unique column
-
Improves CTE/Subquery performance by pruning intermediate rslt broadcasting
-
Removes
citus.worker_list_file
GUC -
Revokes usage from the citus schema from public
-
Fixes a memory leak in the executor
-
Revokes usage from the citus schema from public
-
Adds support for PostgreSQL 12
-
Adds UDFs to help with PostgreSQL upgrades
-
Distributes types to worker nodes
-
Introduces
create_distributed_function
UDF -
Introduces local query execution for Citus MX
-
Implements infrastructure for routing
CALL
to MX workers -
Implements infrastructure for routing
SELECT function()
to MX workers -
Adds support for foreign key constraints between reference tables
-
Adds a feature flag to turn off
CREATE TYPE
propagation -
Adds option
citus.single_shard_commit_protocol
-
Adds support for
EXPLAIN SUMMARY
-
Adds support for
GENERATE ALWAYS AS STORED
-
Adds support for
serial
andsmallserial
in MX mode -
Adds support for anon composite types on the target list in router queries
-
Avoids race condition between
create_reference_table
&master_add_node
-
Fixes a bug in schemas of distributed sequence definitions
-
Fixes a bug that caused
run_command_on_colocated_placements
to fail -
Fixes a bug that leads to various issues when a connection is lost
-
Fixes a schema leak on
CREATE INDEX
statement -
Fixes assert failure in bare
SELECT FROM reference table FOR UPDATE
in MX -
Makes
master_update_node
MX compatible -
Prevents
pg_dist_colocation
from multiple records for reference tables -
Prevents segfault in
worker_partition_protocol
edgecase -
Propagates
ALTER FUNCTION
statements for distributed functions -
Propagates
CREATE OR REPLACE FUNCTION
for distributed functions -
Propagates
REINDEX
on tables & indexes -
Provides a GUC to turn of the new dependency propagation functionality
-
Uses 2PC in adaptive executor when dealing with replication factors above 1
- Fixes performance issues by skipping unnecessary relation access recordings
- Improves Adaptive Executor performance
-
Adds a new distributed executor: Adaptive Executor
-
citus.enable_statistics_collection defaults to off (opt-in)
-
Adds support for CTEs in router planner for modification queries
-
Adds support for propagating SET LOCAL at xact start
-
Adds option to force master_update_node during failover
-
Deprecates master_modify_multiple_shards
-
Improves round robin logic on router queries
-
Creates all distributed schemas as superuser on a separate connection
-
Makes COPY adapt to connection use behaviour of previous commands
-
Replaces SESSION_LIFESPAN with configurable number of connections at xact end
-
Propagates ALTER FOREIGN TABLE commands to workers
-
Don't schedule tasks on inactive nodes
-
Makes DROP/VALIDATE CONSTRAINT tolerant of ambiguous shard extension
-
Fixes an issue with subquery map merge jobs as non-root
-
Fixes null pointers caused by partial initialization of ConnParamsHashEntry
-
Fixes errors caused by joins with shadowed aliases
-
Fixes a regression in outer joining subqueries introduced in 8.2.0
-
Fixes a crash that can occur under high memory load
-
Fixes a bug that selects wrong worker when using round-robin assignment
-
Fixes savepoint rollback after multi-shard modify/copy failure
-
Fixes bad foreign constraint name search
-
Fixes a bug that prevents stack size to be adjusted
- Fixes a bug in outer joins wrapped in subqueries
- Fixes a bug that prevents stack size to be adjusted
-
Don't do redundant ALTER TABLE consistency checks at coordinator
-
Fixes a bug that prevents stack size to be adjusted
-
Fix an issue with some DECLARE .. CURSOR WITH HOLD commands
-
Removes support and code for PostgreSQL 9.6
-
Enable more outer joins with reference tables
-
Execute CREATE INDEX CONCURRENTLY in parallel
-
Treat functions as transaction blocks
-
Add support for column aliases on join clauses
-
Skip standard_planner() for trivial queries
-
Added support for function calls in joins
-
Round-robin task assignment policy relies on local transaction id
-
Relax subquery union pushdown restrictions for reference tables
-
Speed-up run_command_on_shards()
-
Address some memory issues in connection config
-
Restrict visibility of get_*_active_transactions functions to pg_monitor
-
Don't do redundant ALTER TABLE consistency checks at coordinator
-
Queries with only intermediate results do not rely on task assignment policy
-
Finish connection establishment in parallel for multiple connections
-
Fixes a bug related to pruning shards using a coerced value
-
Fix an issue with some DECLARE .. CURSOR WITH HOLD commands
-
Fixes a bug that could lead to infinite recursion during recursive planning
-
Fixes a bug that could prevent planning full outer joins with using clause
-
Fixes a bug that could lead to memory leak on
citus_relation_size
-
Fixes a problem that could cause segmentation fault with recursive planning
-
Switch CI solution to CircleCI
-
Fixes maintenance daemon panic due to unreleased spinlock
-
Fixes an issue with having clause when used with complex joins
-
Fixes maintenance daemon panic due to unreleased spinlock
-
Fixes an issue with having clause when used with complex joins
-
Turns on ssl by default for new installations of citus
-
Restricts SSL Ciphers to TLS1.2 and above
-
Adds support for INSERT INTO SELECT..ON CONFLICT/RETURNING via coordinator
-
Adds support for round-robin task assignment for queries to reference tables
-
Adds support for SQL tasks using worker_execute_sql_task UDF with task-tracker
-
Adds support for VALIDATE CONSTRAINT queries
-
Adds support for disabling hash aggregate with HLL
-
Adds user ID suffix to intermediate files generated by task-tracker
-
Only allow transmit from pgsql_job_cache directory
-
Disallows GROUPING SET clauses in subqueries
-
Removes restriction on user-defined group ID in node addition functions
-
Relaxes multi-shard modify locks when enable_deadlock_prevention is disabled
-
Improves security in task-tracker protocol
-
Improves permission checks in internal DROP TABLE functions
-
Improves permission checks in cluster management functions
-
Cleans up UDFs and fixes permission checks
-
Fixes crashes caused by stack size increase under high memory load
-
Fixes a bug that could cause maintenance daemon panic
-
Fixes a bug that could cause maintenance daemon panic
-
Fixes crashes caused by stack size increase under high memory load
- Fixes a bug that could cause maintenance daemon panic
- Execute SQL tasks using worker_execute_sql_task UDF when using task-tracker
- Execute SQL tasks using worker_execute_sql_task UDF when using task-tracker
-
Fixes inconsistent metadata error when shard metadata caching get interrupted
-
Fixes a bug that could cause memory leak
-
Fixes a bug that prevents recovering wrong transactions in MX
-
Fixes a bug to prevent wrong memory accesses on Citus MX under very high load
-
Fixes crashes caused by stack size increase under high memory load
-
Adds support for PostgreSQL 11
-
Adds support for applying DML operations on reference tables from MX nodes
-
Adds distributed locking to truncated MX tables
-
Adds support for running TRUNCATE command from MX worker nodes
-
Adds views to provide insight about the distributed transactions
-
Adds support for TABLESAMPLE in router queries
-
Adds support for INCLUDE option in index creation
-
Adds option to allow simple DML commands from hot standby
-
Adds support for partitioned tables with replication factor > 1
-
Prevents a deadlock on concurrent DROP TABLE and SELECT on Citus MX
-
Fixes a bug that prevents recovering wrong transactions in MX
-
Fixes a bug to prevent wrong memory accesses on Citus MX under very high load
-
Fixes a bug in MX mode, calling DROP SCHEMA with existing partitioned table
-
Fixes a bug that could cause modifying CTEs to select wrong execution mode
-
Fixes a bug preventing rollback in CREATE PROCEDURE
-
Fixes a bug on not being able to drop index on a partitioned table
-
Fixes a bug on TRUNCATE when there is a foreign key to a reference table
-
Fixes a performance issue in prepared INSERT..SELECT
-
Fixes a bug which causes errors on DROP DATABASE IF EXISTS
-
Fixes a bug to remove intermediate result directory in pull-push execution
-
Improves query pushdown planning performance
-
Evaluate functions anywhere in query
-
Improves query pushdown planning performance
-
Fixes a bug that could cause modifying CTEs to select wrong execution mode
- Fixes a segfault in real-time executor during online shard move
-
Adds foreign key support from hash distributed to reference tables
-
Adds SELECT ... FOR UPDATE support for router plannable queries
-
Adds support for non-partition columns in count distinct
-
Fixes a segfault in real-time executor during online shard move
-
Fixes ALTER TABLE ADD COLUMN constraint check
-
Fixes a bug where INSERT ... SELECT was allowed to update distribution column
-
Allows DDL commands to be sequentialized via
citus.multi_shard_modify_mode
-
Adds support for topn_union_agg and topn_add_agg across shards
-
Adds support for hll_union_agg and hll_add_agg across shards
-
Fixes a bug that might cause shards to have a wrong owner
-
GUC select_opens_transaction_block defers opening transaction block on workers
-
Utils to implement DDLs for policies in future, warn about being unsupported
-
Intermediate results use separate connections to avoid interfering with tasks
-
Adds a node_conninfo GUC to set outgoing connection settings
- Adds support for respecting enable_hashagg in the master planner
-
Fixes a bug that could cause transactions to incorrectly proceed after failure
-
Fixes a bug on INSERT ... SELECT queries in prepared statements
-
Adds support for non-pushdownable subqueries and CTEs in UPDATE/DELETE queries
-
Adds support for pushdownable subqueries and joins in UPDATE/DELETE queries
-
Adds faster shard pruning for subqueries
-
Adds partitioning support to MX table
-
Adds support for (VACUUM | ANALYZE) VERBOSE
-
Adds support for multiple ANDs in
HAVING
for pushdown planner -
Adds support for quotation needy schema names
-
Improves operator check time in physical planner for custom data types
-
Removes broadcast join logic
-
Deprecates
large_table_shard_count
andmaster_expire_table_cache()
-
Modifies master_update_node to lock write on shards hosted by node over update
-
DROP TABLE
now drops shards as the currrent user instead of the superuser -
Adds specialised error codes for connection failures
-
Improves error messages on connection failure
-
Fixes issue which prevented multiple
citus_table_size
calls per query -
Tests are updated to use
create_distributed_table
- Fixes a bug that could cause SELECTs to crash during a rebalance
-
Adds support for non-colocated joins between subqueries
-
Adds support for window functions that can be pushed down to worker
-
Adds support for modifying CTEs
-
Adds recursive plan for subqueries in WHERE clause with recurring FROM clause
-
Adds support for bool_ and bit_ aggregates
-
Adds support for Postgres
jsonb
andjson
aggregation functions -
Adds support for respecting enable_hashagg in the master plan
-
Adds support for renaming a distributed table
-
Adds support for ALTER INDEX (SET|RESET|RENAME TO) commands
-
Adds support for setting storage parameters on distributed tables
-
Performance improvements to reduce distributed planning time
-
Fixes a bug on planner when aggregate is used in ORDER BY
-
Fixes a bug on planner when DISTINCT (ON) clause is used with GROUP BY
-
Fixes a bug of creating coordinator planner with distinct and aggregate clause
-
Fixes a bug that could open a new connection on every table size function call
-
Fixes a bug canceling backends that are not involved in distributed deadlocks
-
Fixes count distinct bug on column expressions when used with subqueries
-
Improves error handling on worker node failures
-
Improves error messages for INSERT queries that have subqueries
-
Fixes count distinct bug on column expressions when used with subqueries
-
Adds support for respecting enable_hashagg in the master plan
-
Fixes a bug canceling backends that are not involved in distributed deadlocks
-
Adds support for CTEs
-
Adds support for subqueries that require merge step
-
Adds support for set operations (UNION, INTERSECT, ...)
-
Adds support for 2PC auto-recovery
-
Adds support for querying local tables in CTEs and subqueries
-
Adds support for more SQL coverage in subqueries for reference tables
-
Adds support for count(distinct) in queries with a subquery
-
Adds support for non-equijoins when there is already an equijoin for queries
-
Adds support for non-equijoins when there is already an equijoin for subquery
-
Adds support for real-time executor to run in transaction blocks
-
Adds infrastructure for storing intermediate distributed query results
-
Adds a new GUC named
enable_repartition_joins
for auto executor switch -
Adds support for limiting the intermediate result size
-
Improves support for queries with unions containing filters
-
Improves support for queries with unions containing joins
-
Improves support for subqueries in the
WHERE
clause -
Increases
COPY
throughput -
Enables pushing down queries containing only recurring tuples and
GROUP BY
-
Load-balance queries that read from 0 shards
-
Improves support for using functions in subqueries
-
Fixes a bug that could cause real-time executor to crash during cancellation
-
Fixes a bug that could cause real-time executor to get stuck on cancellation
-
Fixes a bug that could block modification queries unnecessarily
-
Fixes a bug that could cause assigning wrong IDs to transactions
-
Fixes a bug that could cause an assert failure with
ANALYZE
statements -
Fixes a bug that could allow pushing down wrong set operations in subqueries
-
Fixes a bug that could cause a deadlock in create_distributed_table
-
Fixes a bug that could confuse user about
ANALYZE
usage -
Fixes a bug that could lead to false positive distributed deadlock detections
-
Relaxes the locking for DDL commands on partitioned tables
-
Relaxes the locking on
COPY
with replication -
Logs more remote commands when citus.log_remote_commands is set
- Fixes a bug that could crash the coordinator while reporting a remote error
-
Fixes a bug that could cause assigning wrong IDs to transactions
-
Increases
COPY
throughput
-
Fixes a bug that could prevent pushing down subqueries with reference tables
-
Fixes a bug that could create false positive distributed deadlocks
-
Fixes a bug that could prevent running concurrent COPY and multi-shard DDL
-
Fixes a bug that could mislead users about
ANALYZE
queries
-
Adds support for native queries with multi shard
UPDATE
/DELETE
queries -
Expands reference table support in subquery pushdown
-
Adds window function support for subqueries and
INSERT ... SELECT
queries -
Adds support for
COUNT(DISTINCT) [ON]
queries on non-partition columns -
Adds support for
DISTINCT [ON]
queries on non-partition columns -
Introduces basic usage statistic collector
-
Adds support for setting replica identity while creating distributed tables
-
Adds support for
ALTER TABLE ... REPLICA IDENTITY
queries -
Adds pushdown support for
LIMIT
andHAVING
grouped by partition key -
Adds support for
INSERT ... SELECT
queries via worker nodes on MX clusters -
Adds support for adding primary key using already defined index
-
Adds parameter to shard copy functions to support distinct replication models
-
Changes
shard_name
UDF to omit public schema name -
Adds
master_move_node
UDF to make changes on nodename/nodeport more easy -
Fixes a bug that could cause casting error with
INSERT ... SELECT
queries -
Fixes a bug that could prevent upgrading servers from Citus 6.1
-
Fixes a bug that could prevent attaching partitions to a table in schema
-
Fixes a bug that could prevent adding a node to cluster with reference table
-
Fixes a bug that could cause a crash with
INSERT ... SELECT
queries -
Fixes a bug that could prevent creating a partitoned table on Cloud
-
Implements various performance improvements
-
Adds internal infrastructures and tests to improve development process
-
Addresses various race conditions and deadlocks
-
Improves and standardizes error messages
-
Fixes several bugs that could cause crash
-
Fixes a bug that could cause deadlock while creating reference tables
-
Fixes a bug that could cause false-positives in deadlock detection
-
Fixes a bug that could cause 2PC recovery not to work from MX workers
-
Fixes a bug that could cause cache incohorency
-
Fixes a bug that could cause maintenance daemon to skip cache invalidations
-
Improves performance of transaction recovery by using correct index
- Updates task-tracker to limit file access
- Updates task-tracker to limit file access
- Updates task-tracker to limit file access
-
Fixes a bug that could cause memory leaks in
INSERT ... SELECT
queries -
Fixes a bug that could cause incorrect execution of prepared statements
-
Fixes a bug that could cause excessive memory usage during COPY
-
Incorporates latest changes from core PostgreSQL code
-
Adds support for PostgreSQL 10
-
Drops support for PostgreSQL 9.5
-
Adds support for multi-row
INSERT
-
Adds support for router
UPDATE
andDELETE
queries with subqueries -
Adds infrastructure for distributed deadlock detection
-
Deprecates
enable_deadlock_prevention
flag -
Adds support for partitioned tables
-
Adds support for creating
UNLOGGED
tables -
Adds support for
SAVEPOINT
-
Adds UDF
citus_create_restore_point
for taking distributed snapshots -
Adds support for evaluating non-pushable
INSERT ... SELECT
queries -
Adds support for subquery pushdown on reference tables
-
Adds shard pruning support for
IN
andANY
-
Adds support for
UPDATE
andDELETE
commands that prune down to 0 shard -
Enhances transaction support by relaxing some transaction restrictions
-
Fixes a bug causing crash if distributed table has no shards
-
Fixes a bug causing crash when removing inactive node
-
Fixes a bug causing failure during
COPY
on tables with dropped columns -
Fixes a bug causing failure during
DROP EXTENSION
-
Fixes a bug preventing executing
VACUUM
andINSERT
concurrently -
Fixes a bug in prepared
INSERT
statements containing an implicit cast -
Fixes several issues related to statement cancellations and connections
-
Fixes several 2PC related issues
-
Removes an unnecessary dependency causing warning messages in pg_dump
-
Adds internal infrastructure for follower clusters
-
Adds internal infrastructure for progress tracking
-
Implements various performance improvements
-
Adds internal infrastructures and tests to improve development process
-
Addresses various race conditions and deadlocks
-
Improves and standardizes error messages
-
Fixes a crash during execution of local CREATE INDEX CONCURRENTLY
-
Fixes a bug preventing usage of quoted column names in COPY
-
Fixes a bug in prepared INSERTs with implicit cast in partition column
-
Relaxes locks in VACUUM to ensure concurrent execution with INSERT
- Fixes a common cause of deadlocks when repairing tables with foreign keys
- Relaxes version-check logic to avoid breaking non-distributed commands
-
Increases SQL subquery coverage by pushing down more kinds of queries
-
Adds CustomScan API support to allow read-only transactions
-
Adds support for
CREATE/DROP INDEX CONCURRENTLY
-
Adds support for
ALTER TABLE ... ADD CONSTRAINT
-
Adds support for
ALTER TABLE ... RENAME COLUMN
-
Adds support for
DISABLE/ENABLE TRIGGER ALL
-
Adds support for expressions in the partition column in INSERTs
-
Adds support for query parameters in combination with function evaluation
-
Adds support for creating distributed tables from non-empty local tables
-
Adds UDFs to get size of distributed tables
-
Adds UDFs to add a new node without replicating reference tables
-
Adds checks to prevent running Citus binaries with wrong metadata tables
-
Improves shard pruning performance for range queries
-
Improves planner performance for joins involving co-located tables
-
Improves shard copy performance by creating indexes after copy
-
Improves task-tracker performance by batching several status checks
-
Enables router planner for queries on range partitioned table
-
Changes
TRUNCATE
to drop local data only ifenable_ddl_propagation
is off -
Starts to execute DDL on coordinator before workers
-
Fixes a bug causing incorrectly reading invalidated cache
-
Fixes a bug related to creation of schemas of in workers with incorrect owner
-
Fixes a bug related to concurrent run of shard drop functions
-
Fixes a bug related to
EXPLAIN ANALYZE
with DML queries -
Fixes a bug related to SQL functions in FROM clause
-
Adds a GUC variable to report cross shard queries
-
Fixes a bug related to partition columns without native hash function
-
Adds internal infrastructures and tests to improve development process
-
Addresses various race conditions and deadlocks
-
Improves and standardizes error messages
- Fixes a common cause of deadlocks when repairing tables with foreign keys
-
Fixes a crash caused by router executor use after connection timeouts
-
Fixes a crash caused by relation cache invalidation during COPY
-
Fixes bug related to DDL use within PL/pgSQL functions
-
Fixes a COPY bug related to types lacking binary output functions
-
Fixes a bug related to modifications with parameterized partition values
-
Fixes improper value interpolation in worker sequence generation
-
Guards shard pruning logic against zero-shard tables
-
Fixes possible NULL pointer dereference and buffer underflow (via PVS-Studio)
-
Fixes a INSERT ... SELECT bug that could push down non-partition column JOINs
-
Implements reference tables, transactionally replicated to all nodes
-
Adds
upgrade_to_reference_table
UDF to upgrade pre-6.1 reference tables -
Expands prepared statement support to nearly all statements
-
Adds support for creating
VIEW
s which reference distributed tables -
Adds targeted
VACUUM
/ANALYZE
support -
Adds support for the
FILTER
clause in aggregate expressions -
Adds support for function evaluation within
INSERT INTO ... SELECT
-
Adds support for creating foreign key constraints with
ALTER TABLE
-
Adds logic to choose router planner for all queries it supports
-
Enhances
create_distributed_table
with parameter for explicit colocation -
Adds generally useful utility UDFs previously available as "Citus Tools"
-
Adds user-facing UDFs for locking shard resources and metadata
-
Refactors connection and transaction management; giving consistent experience
-
Enhances
COPY
with fully transactional semantics -
Improves support for cancellation for a number of queries and commands
-
Adds
column_to_column_name
UDF to help users understandpartkey
values -
Adds
master_disable_node
UDF for temporarily disabling nodes -
Adds proper MX ("masterless") metadata propagation logic
-
Adds
start_metadata_sync_to_node
UDF to propagate metadata changes to nodes -
Enhances
SERIAL
compatibility with MX tables -
Adds
node_connection_timeout
parameter to control node connection timeouts -
Adds
enable_deadlock_prevention
setting to permit multi-node transactions -
Adds a
replication_model
setting to specify replication of new tables -
Changes the
shard_replication_factor
setting's default value to one -
Adds code to automatically set
max_prepared_transactions
if not configured -
Accelerates lookup of colocated shard placements
-
Fixes a bug affecting
INSERT INTO ... SELECT
queries using constant values -
Fixes a bug by ensuring
COPY
does not mark placements inactive -
Fixes a bug affecting reads from
pg_dist_shard_placement
table -
Fixes a crash triggered by creating a foreign key without a column
-
Fixes a crash related to accessing catalog tables after aborted transactions
-
Fixes a bug affecting JOIN queries requiring repartitions
-
Fixes a bug affecting node insertions to
pg_dist_node
table -
Fixes a crash triggered by queries with modifying common table expressions
-
Fixes a bug affecting workloads with concurrent shard appends and deletions
-
Addresses various race conditions and deadlocks
-
Improves and standardizes error messages
-
Fixes a bug causing failures during pg_upgrade
-
Fixes a bug preventing DML queries during colocated table creation
-
Fixes a bug that caused NULL parameters to be incorrectly passed as text
-
Adds compatibility with PostgreSQL 9.6, now the recommended version
-
Removes the
pg_worker_list.conf
file in favor of apg_dist_node
table -
Adds
master_add_node
andmaster_add_node
UDFs to manage membership -
Removes the
\stage
command and corresponding csql binary in favor ofCOPY
-
Removes
copy_to_distributed_table
in favor of first-classCOPY
support -
Adds support for multiple DDL statements within a transaction
-
Adds support for certain foreign key constraints
-
Adds support for parallel
INSERT INTO ... SELECT
against colocated tables -
Adds support for the
TRUNCATE
command -
Adds support for
HAVING
clauses inSELECT
queries -
Adds support for
EXCLUDE
constraints which include the partition column -
Adds support for system columns in queries (
tableoid
,ctid
, etc.) -
Adds support for relation name extension within
INDEX
definitions -
Adds support for no-op
UPDATE
s of the partition column -
Adds several general-purpose utility UDFs to aid in Citus maintenance
-
Adds
master_expire_table_cache
UDF to forcibly expire cached shards -
Parallelizes the processing of DDL commands which affect distributed tables
-
Adds support for repartition jobs using composite or custom types
-
Enhances object name extension to handle long names and large shard counts
-
Parallelizes the
master_modify_multiple_shards
UDF -
Changes distributed table creation to error if the target table is not empty
-
Changes the
pg_dist_shard.logicalrelid
column from anoid
toregclass
-
Adds a
placementid
column topg_dist_shard_placement
, replacing Oid use -
Removes the
pg_dist_shard.shardalias
distribution metadata column -
Adds
pg_dist_partition.repmodel
to track tables using streaming replication -
Adds internal infrastructure to take snapshots of distribution metadata
-
Addresses the need to invalidate prepared statements on metadata changes
-
Adds a
mark_tables_colocated
UDF for denoting pre-6.0 manual colocation -
Fixes a bug affecting prepared statement execution within PL/pgSQL
-
Fixes a bug affecting
COPY
commands using composite types -
Fixes a bug that could cause crashes during
EXPLAIN EXECUTE
-
Separates worker and master job temporary folders
-
Eliminates race condition between distributed modification and repair
-
Relaxes the requirement that shard repairs also repair colocated shards
-
Implements internal functions to track which tables' shards are colocated
-
Adds
pg_dist_partition.colocationid
to track colocation group membership -
Extends shard copy and move operations to respect colocation settings
-
Adds
pg_dist_local_group
to prepare for future MX-related changes -
Adds
create_distributed_table
to easily create shards and infer colocation
-
Adds support for
IF NOT EXISTS
clause ofCREATE INDEX
command -
Adds support for
RETURN QUERY
andFOR ... IN
PL/pgSQL features -
Extends the router planner to handle more queries
-
Changes
COUNT
of zero-row sets to return0
rather than an empty result -
Reduces the minimum permitted
task_tracker_delay
to a single millisecond -
Fixes a bug that caused crashes during joins with a
WHERE false
clause -
Fixes a bug triggered by unique violation errors raised in long transactions
-
Fixes a bug resulting in multiple registration of transaction callbacks
-
Fixes a bug which could result in stale reads of distribution metadata
-
Fixes a bug preventing distributed modifications in some PL/pgSQL functions
-
Fixes some code paths that could hypothetically read uninitialized memory
-
Lowers log level of waiting for activity messages
-
Fixes subquery pushdown to properly extract outer join qualifiers
-
Addresses possible memory leak during multi-shard transactions
-
Drops support for PostgreSQL 9.4; PostgreSQL 9.5 is required
-
Adds schema support for tables, other named objects (types, operators, etc.)
-
Evaluates non-immutable functions on master in all modification commands
-
Adds support for SERIAL types in non-partition columns
-
Adds support for RETURNING clause in INSERT, UPDATE, and DELETE commands
-
Adds support for multi-statement transactions involving a fixed set of nodes
-
Full SQL support for SELECT queries which can be executed on a single worker
-
Adds option to perform DDL changes using prepared transactions (2PC)
-
Adds an
enable_ddl_propagation
parameter to control DDL propagation -
Accelerates shard pruning during merges
-
Adds
master_modify_multiple_shards
UDF to modify many shards at once -
Adds COPY support for arrays of user-defined types
-
Now supports parameterized prepared statements for certain use cases
-
Extends LIMIT/OFFSET support to all executor types
-
Constraint violations now fail fast rather than hitting all placements
-
Makes
master_create_empty_shard
aware of shard placement policy -
Reduces unnecessary sleep during queries processed by real-time executor
-
Improves task tracker executor's task cleanup logic
-
Relaxes restrictions on cancellation of DDL commands
-
Removes ONLY keyword from worker SELECT queries
-
Error message improvements and standardization
-
Moves
master_update_shard_statistics
function topg_catalog
schema -
Fixes a bug where hash-partitioned anti-joins could return incorrect results
-
Now sets storage type correctly for foreign table-backed shards
-
Fixes
master_update_shard_statistics
issue with hash-partitioned tables -
Fixes an issue related to extending table names that require escaping
-
Reduces risk of row counter overflows during modifications
-
Fixes a crash related to FILTER clause use in COUNT DISTINCT subqueries
-
Fixes crashes related to partition columns with high attribute numbers
-
Fixes certain subquery and join crashes
-
Detects flex for build even if PostgreSQL was built without it
-
Fixes assert-enabled crash when
all_modifications_commutative
is true
- Initial 5.2.0 candidate
-
Adds complex count distinct expression support in repartitioned subqueries
-
Improves task tracker job cleanup logic, addressing a memory leak
-
Fixes bug that generated incorrect results for LEFT JOIN queries
-
Improves compatibility with Debian's reproducible builds project
-
Fixes build issues on FreeBSD platforms
-
Adds distributed COPY to rapidly populate distributed tables
-
Adds support for using EXPLAIN on distributed queries
-
Recognizes and fast-paths single-shard SELECT statements automatically
-
Increases INSERT throughput via shard pruning optimizations
-
Improves planner performance for joins involving tables with many shards
-
Adds ability to pass columns as arguments to function calls in UPDATEs
-
Introduces transaction manager for use by multi-shard commands
-
Adds COUNT(DISTINCT ...) pushdown optimization for hash-partitioned tables
-
Adds support for certain UNIQUE indexes on hash- or range-partitioned tables
-
Deprecates \stage in favor of using COPY for append-partition tables
-
Deprecates
copy_to_distributed_table
in favor of first-class COPY support -
Fixes build problems when using non-packaged PostgreSQL installs
-
Fixes bug that sometimes skipped pruning when partitioned by a VARCHAR column
-
Fixes bug impeding use of user-defined functions in repartitioned subqueries
-
Fixes bug involving queries with equality comparisons of boolean types
-
Fixes crash that prevented use alongside
pg_stat_statements
-
Fixes crash arising from SELECT queries that lack a target list
-
Improves warning and error messages
-
Fixes test failures
-
Fixes EXPLAIN output when FORMAT JSON in use
- Initial 5.1.0 candidate
- Fixes issues on 32-bit systems
-
Public release under AGPLv3
-
PostgreSQL extension compatible with PostgreSQL 9.5 and 9.4