Prerequisites 932 Install Docker 932 Install PL/Container 933 Install PL/Container Docker Images 935 Test the PL/Container Installation 937 Upgrade PL/Container 938 Uninstall PL/Container 939 Uninstall staging table name when the name was enclosed in double quotes. 13399 Adds SSL connection regression test cases. Release 6.20.1 Release Date: 2022-03-25 VMware Tanzu Greenplum 6.20.1 is a maintenance release where gpcheckcat returned the error invalid input syntax for integer during the orphaned_toast_tables test because the command did not correctly handle a temporary toast table. 12957 Resolves an issue where

904 Install PL/Container Docker Images 905 VMware Tanzu Greenplum 6 Documentation VMware, Inc 39 Test the PL/Container Installation 907 Upgrade PL/Container 908 Uninstall PL/Container 909 Uninstall staging table name when the name was enclosed in double quotes. 13399 Adds SSL connection regression test cases. Release 6.20.1 Release Date: 2022-03-25 VMware Tanzu Greenplum 6.20.1 is a maintenance release where gpcheckcat returned the error invalid input syntax for integer during the orphaned_toast_tables test because the command did not correctly handle a temporary toast table. 12957 Resolves an issue where

Prerequisites 901 Install Docker 901 Install PL/Container 902 Install PL/Container Docker Images 903 Test the PL/Container Installation 905 Upgrade PL/Container 907 Uninstall PL/Container 908 Uninstall staging table name when the name was enclosed in double quotes. 13399 : Adds SSL connection regression test cases. VMware Tanzu Greenplum 6 Documentation VMware, Inc. 150 Release 6.20.1 Release Date: 2022-03-25 where gpcheckcat returned the error invalid input syntax for integer during the orphaned_toast_tables test because the command did not correctly handle a temporary toast table. 12957 Resolves an issue where

for Graphical control of WLM 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 GPCC New UI Glance 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 Greenplum Workload Manager Rule Pull Request(PR): 31 open, 987 closed within 12 months – External contributions from China: China Mobile, Alibaba, Huawei, … • User groups without any advertisement – wechat group: 436 2016Postgres中国用户大会

Prerequisites 942 Install Docker 943 Install PL/Container 944 Install PL/Container Docker Images 945 Test the PL/Container Installation 947 Upgrade PL/Container 948 VMware Greenplum 6 Documentation VMware Greenplum Database has been updated to version 1.21.0. The gpcheckcat utility now includes a new test -- mix_distribution_policy -- which checks for tables created with legacy and non-legacy hash operations staging table name when the name was enclosed in double quotes. 13399 : Adds SSL connection regression test cases. Release 6.20.1 Release Date: 2022-03-25 VMware Greenplum 6.20.1 is a maintenance release

Creating the Greenplum Template 313 Validating the Template 313 Creating a Test Virtual Machine 313 Verifying the Test Virtual Machine Settings 314 Allocating the Virtual Machines with Terraform 317 Prerequisites 787 Install Docker 787 Install PL/Container 788 Install PL/Container Docker Images 789 Test the PL/Container Installation 791 Upgrade PL/Container 792 Uninstall PL/Container 793 Uninstall staging table name when the name was enclosed in double quotes. 13399 Adds SSL connection regression test cases. Release 6.20.1 Release Date: 2022-03-25 VMware Tanzu Greenplum 6.20.1 is a maintenance release

Prerequisites 913 Install Docker 914 Install PL/Container 915 Install PL/Container Docker Images 916 Test the PL/Container Installation 918 Upgrade PL/Container 919 Uninstall PL/Container 920 Uninstall staging table name when the name was enclosed in double quotes. 13399 : Adds SSL connection regression test cases. Release 6.20.1 Release Date: 2022-03-25 VMware Greenplum 6.20.1 is a maintenance release where gpcheckcat returned the error invalid input syntax for integer during the orphaned_toast_tables test because the command did not correctly handle a temporary toast table. 12957 Resolves an issue where

于区别度低的字段（<10000),采用 Bitmap索引； • 表关联时，一般不需要建索引，如果where条件的筛选性很强，建立索引可以让系统性能提升 • 对于大数据类系统，应避免使用PK,UI,FK,唯一性约束或参考性检查将导致性能大幅下降； • 大数量更新时，应先删除索引，更新/加载数据后再重建索引，或者采用分区交换降低对目标表的影响 临时空间的监控和管理  临时空间被无限 – 检查网络是否故障 – 检查实例的进程是否存在，ps –ef |grep postgres|grep port – 检查文件系统是否有异常（到相应实例对应的数据目录下，执行ls；echo“test‖ > mytest.txt看看是否有错误） 问题定位方法 现象-某个SQL任务执行时间太长  检查SQL是否在资源队列中排队（select *

PL Languages/Container Confidential │ ©2022 VMware, Inc. 19 GPCC Greenplum Command Center Ø Web UI 监控和管理 Ø 实时性能监控 Ø 可视化计划 Ø 基于规则的任务管理 Ø 向客户推荐性能优化操作 Ø 报警和通知 Confidential │ ©2022 VMware, Inc. 20

429 Install PL/Container Docker Images 430 VMware Greenplum v6.19 Documentation VMware, Inc. 21 Test the PL/Container Installation 432 Upgrade PL/Container 434 Uninstall PL/Container 435 Uninstall must configure SELinux contexts, policies, and domains based on your security requirements, and test your configuration to ensure there is no functionality or performance impact to Greenplum Database where gpcheckcat returned the error invalid input syntax for integer during the orphaned_toast_tables test because the command did not correctly handle a VMware Greenplum v6.19 Documentation VMware, Inc