citus (6.0.1.PGDG-1) unstable; urgency=low * 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 -- Burak Yucesoy Wed, 30 Nov 2016 15:27:38 +0000 citus (6.0.0.PGDG-1) unstable; urgency=low * Adds compatibility with PostgreSQL 9.6, now the recommended version * Removes the pg_worker_list.conf file in favor of a pg_dist_node table * Adds master_add_node and master_add_node UDFs to manage membership * Removes the \stage command and corresponding csql binary in favor of COPY * Removes copy_to_distributed_table in favor of first-class COPY 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 in SELECT 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 UPDATEs 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 an oid to regclass * Adds a placementid column to pg_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 -- Jason Petersen Tue, 8 Nov 2016 19:45:45 +0000 citus (5.2.2.PGDG-1) unstable; urgency=low * Adds support for IF NOT EXISTS clause of CREATE INDEX command * Adds support for RETURN QUERY and FOR ... IN PL/pgSQL features * Extends the router planner to handle more queries * Changes COUNT of zero-row sets to return 0 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 -- Jason Petersen Tue, 8 Nov 2016 18:43:37 +0000 citus (5.2.1.PGDG-1) unstable; urgency=low * Fixes subquery pushdown to properly extract outer join qualifiers * Addresses possible memory leak during multi-shard transactions -- Jason Petersen Tue, 6 Sep 2016 20:47:15 +0000 citus (5.2.0.PGDG-1) unstable; urgency=low * Drops support for PostgreSQL 9.4; PostgreSQL 9.5 is required * Adds schema support for tables, 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 using a fixed set of nodes * Full SQL support for SELECT queries which can be executed on 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 to pg_catalog schema * Fixes a bug where hash-partitioned anti-joins could return bad 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 -- Jason Petersen Wed, 17 Aug 2016 10:23:21 +0000 citus (5.1.1-1) unstable; urgency=low * 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 -- Jason Petersen Fri, 17 Jun 2016 16:20:15 +0000 citus (5.1.0-1) unstable; urgency=low * 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 some 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 VARCHAR column * Fixes bug impeding use of user 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 -- Jason Petersen Tue, 17 May 2016 16:55:02 +0000 citus (5.0.1-1) unstable; urgency=low * Fixes issues on 32-bit systems -- Jason Petersen Fri, 15 Apr 2016 19:17:35 +0000 citus (5.0.0-1) unstable; urgency=low * Initial release -- Jason Petersen Thu, 24 Mar 2016 10:12:52 -0400