Citus v6.0.0 發布 ,PostgreSQL的擴展

jopen 8年前發布 | 7K 次閱讀 Citus PostgreSQL

 

Citus為PostgreSQL加入了橫向擴展和并行查詢處理功能，它被云服務公司如CloudFlare用于擴展PostgreSQL，快速分析實時數據。

 

更新日志

  • 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

下載

本站原創，轉載時保留以下信息：
本文轉自：深度開源（open-open.com）
原文地址：http://www.baiduhome.net/news/view/4d3cc23d

 

 本文由用戶 jopen 自行上傳分享，僅供網友學習交流。所有權歸原作者，若您的權利被侵害，請聯系管理員。
 轉載本站原創文章，請注明出處，并保留原始鏈接、圖片水印。
 本站是一個以用戶分享為主的開源技術平臺，歡迎各類分享！
  本文地址：http://www.baiduhome.net/news/view/4d3cc23d