<p style="text-align: center;"><strong><img alt="" src="https://simg.open-open.com/show/2ffa5ffaf48e868f6d963f3155e62d60.png" /></strong></p> <p> </p> <p>Citus为PostgreSQL加入了横向扩展和并行查询处理功能,它被云服务公司如CloudFlare用于扩展PostgreSQL,快速分析实时数据。</p> <p style="text-align: center;"><a href="https://simg.open-open.com/show/ed4f132041cc64aab7b99dc518262054.gif"><img alt="" src="https://simg.open-open.com/show/ed4f132041cc64aab7b99dc518262054.gif" /></a></p> <p> </p> <h2>更新日志</h2> <ul> <li>Adds compatibility with PostgreSQL 9.6, now the recommended version</li> <li>Removes the pg_worker_list.conf file in favor of a pg_dist_node table</li> <li>Adds master_add_node and master_add_node UDFs to manage membership</li> <li>Removes the \stage command and corresponding csql binary in favor of COPY</li> <li>Removes copy_to_distributed_table in favor of first-class COPY support</li> <li>Adds support for multiple DDL statements within a transaction</li> <li>Adds support for certain foreign key constraints</li> <li>Adds support for parallel INSERT INTO ... SELECT against colocated tables</li> <li>Adds support for the TRUNCATE command</li> <li>Adds support for HAVING clauses in SELECT queries</li> <li>Adds support for EXCLUDE constraints which include the partition column</li> <li>Adds support for system columns in queries (tableoid, ctid, etc.)</li> <li>Adds support for relation name extension within INDEX definitions</li> <li>Adds support for no-op UPDATEs of the partition column</li> <li>Adds several general-purpose utility UDFs to aid in Citus maintenance</li> <li>Adds master_expire_table_cache UDF to forcibly expire cached shards</li> <li>Parallelizes the processing of DDL commands which affect distributed tables</li> <li>Adds support for repartition jobs using composite or custom types</li> <li>Enhances object name extension to handle long names and large shard counts</li> <li>Parallelizes the master_modify_multiple_shards UDF</li> <li>Changes distributed table creation to error if the target table is not empty</li> <li>Changes the pg_dist_shard.logicalrelid column from an oid to regclass</li> <li>Adds a placementid column to pg_dist_shard_placement, replacing Oid use</li> <li>Removes the pg_dist_shard.shardalias distribution metadata column</li> <li>Adds pg_dist_partition.repmodel to track tables using streaming replication</li> <li>Adds internal infrastructure to take snapshots of distribution metadata</li> <li>Addresses the need to invalidate prepared statements on metadata changes</li> <li>Adds a mark_tables_colocated UDF for denoting pre-6.0 manual colocation</li> <li>Fixes a bug affecting prepared statement execution within PL/pgSQL</li> <li>Fixes a bug affecting COPY commands using composite types</li> <li>Fixes a bug that could cause crashes during EXPLAIN EXECUTE</li> <li>Separates worker and master job temporary folders</li> <li>Eliminates race condition between distributed modification and repair</li> <li>Relaxes the requirement that shard repairs also repair colocated shards</li> <li>Implements internal functions to track which tables' shards are colocated</li> <li>Adds pg_dist_partition.colocationid to track colocation group membership</li> <li>Extends shard copy and move operations to respect colocation settings</li> <li>Adds pg_dist_local_group to prepare for future MX-related changes</li> <li>Adds create_distributed_table to easily create shards and infer colocation</li> </ul> <h2>下载</h2> <ul> <li><a href="/misc/goto?guid=4958995176084520879" rel="nofollow"><strong>citus-6.0.0.tar.gz.asc</strong></a></li> <li><a href="/misc/goto?guid=4958995176195400104" rel="nofollow"><strong>Source code</strong> (zip)</a></li> <li><a href="/misc/goto?guid=4958995176316868321" rel="nofollow"><strong>Source code</strong> (tar.gz)</a></li> </ul> <p>本站原创,转载时保留以下信息:<br /> 本文转自:深度开源(open-open.com)<br /> 原文地址:<a href="http://www.open-open.com/news/view/4d3cc23d">http://www.open-open.com/news/view/4d3cc23d</a></p> <p> </p>