Contents
-
-
- citus v6.0.0 (November 7, 2016)
- citus v5.2.2 (November 7, 2016)
- citus v5.2.1 (September 6, 2016)
- citus v5.2.0 (August 15, 2016)
- citus v5.2.0-rc.1 (August 1, 2016)
- citus v5.1.1 (June 17, 2016)
- citus v5.1.0 (May 17, 2016)
- citus v5.1.0-rc.2 (May 10, 2016)
- citus v5.1.0-rc.1 (May 4, 2016)
- citus v5.0.1 (April 15, 2016)
- citus v5.0.0 (March 24, 2016)
-
citus v6.0.0 (November 7, 2016)
Adds compatibility with PostgreSQL 9.6, now the recommended version
Removes the
pg_worker_list.conf
file in favor of apg_dist_node
tableAdds
master_add_node
andmaster_add_node
UDFs to manage membershipRemoves the
\stage
command and corresponding csql binary in favor ofCOPY
Removes
copy_to_distributed_table
in favor of first-classCOPY
supportAdds support for multiple DDL statements within a transaction
Adds support for certain foreign key constraints
Adds support for parallel
INSERT INTO ... SELECT
against colocated tablesAdds support for the
TRUNCATE
commandAdds support for
HAVING
clauses inSELECT
queriesAdds support for
EXCLUDE
constraints which include the partition columnAdds support for system columns in queries (
tableoid
,ctid
, etc.)Adds support for relation name extension within
INDEX
definitionsAdds support for no-op
UPDATE
s of the partition columnAdds several general-purpose utility UDFs to aid in Citus maintenance
Adds
master_expire_table_cache
UDF to forcibly expire cached shardsParallelizes 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
UDFChanges 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 useRemoves the
pg_dist_shard.shardalias
distribution metadata columnAdds
pg_dist_partition.repmodel
to track tables using streaming replicationAdds 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 colocationFixes a bug affecting prepared statement execution within PL/pgSQL
Fixes a bug affecting
COPY
commands using composite typesFixes 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 membershipExtends shard copy and move operations to respect colocation settings
Adds
pg_dist_local_group
to prepare for future MX-related changesAdds
create_distributed_table
to easily create shards and infer colocation
citus v5.2.2 (November 7, 2016)
Adds support for
IF NOT EXISTS
clause ofCREATE INDEX
commandAdds support for
RETURN QUERY
andFOR ... IN
PL/pgSQL featuresExtends the router planner to handle more queries
Changes
COUNT
of zero-row sets to return0
rather than an empty resultReduces the minimum permitted
task_tracker_delay
to a single millisecondFixes a bug that caused crashes during joins with a
WHERE false
clauseFixes 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
citus v5.2.1 (September 6, 2016)
Fixes subquery pushdown to properly extract outer join qualifiers
Addresses possible memory leak during multi-shard transactions
citus v5.2.0 (August 15, 2016)
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 propagationAccelerates shard pruning during merges
Adds
master_modify_multiple_shards
UDF to modify many shards at onceAdds 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 policyReduces 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
schemaFixes 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 tablesFixes 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
citus v5.2.0-rc.1 (August 1, 2016)
- Initial 5.2.0 candidate
citus v5.1.1 (June 17, 2016)
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
citus v5.1.0 (May 17, 2016)
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 supportFixes 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
citus v5.1.0-rc.2 (May 10, 2016)
Fixes test failures
Fixes EXPLAIN output when FORMAT JSON in use
citus v5.1.0-rc.1 (May 4, 2016)
- Initial 5.1.0 candidate
citus v5.0.1 (April 15, 2016)
- Fixes issues on 32-bit systems
citus v5.0.0 (March 24, 2016)
Public release under AGPLv3
PostgreSQL extension compatible with PostgreSQL 9.5 and 9.4