Citus v6.0.0 发布 ,PostgreSQL的扩展

jopen 5年前
   <p style="text-align: center;"><strong><img alt="" src="" /></strong></p>    <p> </p>    <p>Citus为PostgreSQL加入了横向扩展和并行查询处理功能,它被云服务公司如CloudFlare用于扩展PostgreSQL,快速分析实时数据。</p>    <p style="text-align: center;"><a href=""><img alt="" src="" /></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 /> 本文转自:深度开源(<br /> 原文地址:<a href=""></a></p>    <p> </p>