diskquota can also now enforce quota hard limits if a query exceeds a disk quota during execution, diskquota terminates the query. This version introduces support for schema and role tablespace disk quotas as well as per-segment tablespace quotas. Greenplum Database 6.21.0 includes version 2.0 of the diskquota module. Greenplum Database 6.21.0 introduces a new module, gp_percentile_agg, that you can use to improve GPORCA plan generation performance for queries that include ordered-set aggregate functions such as percentile_cont(), percentile_disc(), and median(). If the memory configuration on your Greenplum Database master and segment hosts differ and you prefer that the maximum per-transaction memory calculation be based on the segment host configuration, set the parameter to true. The default value of this parameter is false Greenplum Database calculates the maximum per-query memory based on the memory configuration and the number of primary segments on the master host. Greenplum Database introduces the new resource group server configuration parameter gp_resource_group_enable_recalculate_query_mem. Greenplum Database introduces a new server configuration parameter, gp_log_endpoints, that you can use to enable logging of parallel retrieve cursor endpoint details. Log messages that are generated for connection checks between the Query Executor and Query Dispatcher now include the error number that was generated by the receiver. This reduces port usage on segment hosts and prevents interconnect traffic from being routed through unintended (and possibly slower) network interfaces. This allows users, if their configuration permits, to specify that Greenplum use a unicast address - rather than a wildcard address - for interconnect sockets. Greenplum Database now includes a configuration parameter - gp_interconnect_address_type - to specify the type of address binding strategy Greenplum Database uses for communication between segment host sockets. Refer to Protecting Passwords in Greenplum Database for more information. Greenplum Database 6.21.0 adds support for both the SCRAM-SHA-256 password hashing algorithm and the scram-sha-256 client authentication method. Greenplum Database now supports the SET TRANSACTION SNAPSHOT command. The greenplum_fdw contrib module is no longer Beta, it is promoted to a supported feature. The gp_parallel_retrieve_cursor contrib module is no longer Beta, it is promoted to a supported feature. This option is particularly useful for metadata-only operations. The LOCK TABLE SQL command now includes a MASTER ONLY option when enabled, Greenplum Database locks tables on the master only, rather than on the master and all of the segments. Greenplum Database 6.21.0 includes these new and changed features: VMware Tanzu Greenplum 6.21.0 is a minor release that includes feature changes and resolves several issues. See Upgrading to Greenplum 6 to upgrade your existing Greenplum software. VMware Tanzu Greenplum 6 is based on the open source Greenplum Database project code. VMware Tanzu Greenplum 6 software is available for download from the VMware Tanzu Greenplum page on VMware Tanzu Network. For information about Greenplum Database end of life, see VMware Tanzu Greenplum Database end of life policy. For previous versions of the release notes for Greenplum Database, go to VMware Tanzu Greenplum Database Documentation. This document contains release information about VMware Tanzu Greenplum Database 6.x releases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |