如：  一键式集群安装部署初始化命令  Master 和 Standby 自动切换命令  更灵活的并行数据库备份恢复命令  高速 DDL 备份命令  并行 DDL 恢复命令  更先进的跨集群数据同步命令  集群间的表结构差异增量比对命令  良好兼容的 pgAdminIII 客户端  改善的 gpexpand 具有权限查看 pg_authid 系统表的用户都可以看到加密后的密码，不过这些密码都是 经过 MD5 加密后的字符串，由于 MD5 加密算法的不可逆性，查看者无法看到真实的原 始明文密码。当进行 DDL 的备份和恢复时，操作的是加密后的字符串，无法获取真实 的明文密码串。在设置密码的时候，密码就被加密了： =# CREATE USER name WITH ENCRYPTED PASSWORD 是编者自己修改编译的版本，不再是网上直接找到的版 本，目前已经针对 6 版本完成了必要的适配和优化，同时支持 4 版本和 5 版本，能够 正确的显示资源组和资源队列的信息，修复了资源队列刷新的 BUG，外部表的 DDL 信 息正确显示，物化视图，数据表的 UNLOGGED 属性等正确显示，表空间定义的正确显 示，数据库中的对象都按照登录角色的权限只显示应该看得到的对象，包括字段权限。 不过，编者在 github

Tables 782 Queries that Contain Subqueries 783 Queries that Contain Common Table Expressions 784 DML Operation Enhancements with GPORCA 785 VMware Greenplum 6 Documentation VMware by Broadcom 37 Changed optimizer_discard_redistribute_hashjoin 1950 optimizer_enable_associativity 1950 optimizer_enable_dml 1951 optimizer_enable_indexonlyscan 1951 optimizer_enable_master_only_queries 1951 optimizer_en issues. 32683 Resolves an issue where minirepro diagnostic tool did not collect view statistics nor DDL when the query contained an EXPLAIN command. MADlib 32672 The database hung for a period of time

Tables 774 Queries that Contain Subqueries 775 Queries that Contain Common Table Expressions 776 DML Operation Enhancements with GPORCA 777 Changed Behavior with GPORCA 777 GPORCA Limitations 778 Unsupported optimizer_discard_redistribute_hashjoin 1914 optimizer_enable_associativity 1915 optimizer_enable_dml 1915 optimizer_enable_indexonlyscan 1915 optimizer_enable_master_only_queries 1916 optimizer_en issues. 32683 Resolves an issue where minirepro diagnostic tool did not collect view statistics nor DDL when the query contained an EXPLAIN command. MADlib 32672 Resolves an issue where the database

Tables 753 Queries that Contain Subqueries 754 Queries that Contain Common Table Expressions 755 DML Operation Enhancements with GPORCA 756 Changed Behavior with GPORCA 757 GPORCA Limitations 758 Unsupported optimizer_discard_redistribute_hashjoin 1909 optimizer_enable_associativity 1909 optimizer_enable_dml 1910 optimizer_enable_indexonlyscan 1910 optimizer_enable_master_only_queries 1910 optimizer_en issues. 32683 Resolves an issue where minirepro diagnostic tool did not collect view statistics nor DDL when the query contained an EXPLAIN command. MADlib 32672 The database hung for a period of time

Tables 863 Queries that Contain Subqueries 864 Queries that Contain Common Table Expressions 865 DML Operation Enhancements with GPORCA 866 Changed Behavior with the GPORCA 866 Changed Behavior with Greenplum v6.18 Documentation VMware, Inc. 116 optimizer_enable_associativity 1622 optimizer_enable_dml 1622 optimizer_enable_indexonlyscan 1623 optimizer_enable_master_only_queries 1623 optimizer_en been resolved. Server 12197 : Resolves a data corruption issue that could occur with concurrent DML queries on AO/AOCO tables when Greenplum Database was not aware of committed transactions that started

Tables 872 Queries that Contain Subqueries 873 Queries that Contain Common Table Expressions 874 DML Operation Enhancements with GPORCA 875 Changed Behavior with the GPORCA 875 Changed Behavior with optimizer_cte_inlining_bound 1632 optimizer_dpe_stats 1632 optimizer_enable_associativity 1632 optimizer_enable_dml 1633 optimizer_enable_indexonlyscan 1633 optimizer_enable_master_only_queries 1634 optimizer_en been resolved. Server 12197 : Resolves a data corruption issue that could occur with concurrent DML queries on AO/AOCO tables when Greenplum Database was not aware of committed transactions that started

Tables 746 Queries that Contain Subqueries 748 Queries that Contain Common Table Expressions 749 DML Operation Enhancements with GPORCA 749 Changed Behavior with GPORCA 750 GPORCA Limitations 751 Unsupported optimizer_cte_inlining_bound 1851 optimizer_dpe_stats 1851 optimizer_enable_associativity 1851 optimizer_enable_dml 1851 optimizer_enable_indexonlyscan 1852 optimizer_enable_master_only_queries 1852 optimizer_en to produce a plan when the query involved an update on a partitioned table by removing an unused DML column. 32291 Resolves an issue where GPORCA generated a poor plan because it did not identify operation

Tables 746 Queries that Contain Subqueries 747 Queries that Contain Common Table Expressions 748 DML Operation Enhancements with GPORCA 748 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 33 Changed optimizer_cte_inlining_bound 1843 optimizer_dpe_stats 1843 optimizer_enable_associativity 1843 optimizer_enable_dml 1844 optimizer_enable_indexonlyscan 1844 optimizer_enable_master_only_queries 1844 optimizer_en optimizer_enable_replicated_table, that you can use to control GPORCA's behavior when it encounters DML operations on replicated tables. By default, GPORCA attempts to plan and execute operations on replicated

Broadcom 24 Queries that Contain Subqueries 578 Queries that Contain Common Table Expressions 579 DML Operation Enhancements with GPORCA 580 Changed Behavior with GPORCA 581 GPORCA Limitations 582 Unsupported optimizer_discard_redistribute_hashjoin 1770 optimizer_enable_associativity 1770 optimizer_enable_dml 1770 optimizer_enable_dynamicindexonlyscan 1771 optimizer_enable_foreign_table 1771 optimizer_enable_indexonlyscan integer data type. This simplifies the creation of sequences matching the range of base columns. Some DDL commands now accept the current user (CURRENT_USER) or the session user (SESSION_USER) in place of

Tables 864 Queries that Contain Subqueries 865 Queries that Contain Common Table Expressions 866 DML Operation Enhancements with GPORCA 867 Changed Behavior with GPORCA 867 GPORCA Limitations 868 Unsupported VMware, Inc. 109 optimizer_dpe_stats 1645 optimizer_enable_associativity 1645 optimizer_enable_dml 1645 optimizer_enable_indexonlyscan 1646 optimizer_enable_master_only_queries 1646 optimizer_en been resolved. Server 12197 : Resolves a data corruption issue that could occur with concurrent DML queries on AO/AOCO tables when Greenplum Database was not aware of committed transactions that started