............................................................................7 Greenplum资源组和Workload Manager ........................................................................................... 地理空间 公有云 私有云 完全 托管云 本地 BI / 报告 自定义应用 机器学习 AI SQL 大规模 并行处理 (MPP) PB 级数据 加载 查询 优化器 (GPORCA) Workload Manager 多态存储 Command Center SQL 兼容性 (Hyper-Q) PostgreSQL 内核 JSON、Apache AVRO、Apache Parquet 和 XML 实现性能提升。随着 GPORCA 的功能逐渐增多，传统查询优化器能够在性能上胜出 的情况将变得极为罕见。4 Greenplum资源组和Workload Manager 管理并发性能和用户资源分配是 Greenplum 的主要功能之一。这一版本不仅增强了 Workload Manager 的功能，还引入了 一种管理数据库查询的新方法——资源组，可让数据库管理员更好地控制用户活动，尤其是在 CPU 和内存管理方面。资

Storage Plugin with gpbackup, gprestore, and gpbackup_manager 564 Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup_manager 0 DD Boost Storage Plugin Configuration File Format 564 Performance Factors 994 VMware Greenplum v6.18 Documentation VMware, Inc. 57 System Resources 995 Workload 995 Throughput 995 Contention 995 Optimization 995 Determining Acceptable Performance 996 Baseline Common Causes of Performance Issues 0 Identifying Hardware and Segment Failures 998 Managing Workload 999 Avoiding Contention 999 Maintaining Database Statistics 999 Identifying Statistics Problems

Storage Plugin with gpbackup, gprestore, and gpbackup_manager 573 Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup_manager 0 DD Boost Storage Plugin Configuration File Format 573 Performance Factors 1003 VMware Greenplum v6.19 Documentation VMware, Inc. 58 System Resources 1004 Workload 1004 Throughput 1004 Contention 1004 Optimization 1004 Determining Acceptable Performance 1005 Common Causes of Performance Issues 0 Identifying Hardware and Segment Failures 1007 Managing Workload 1008 Avoiding Contention 1008 Maintaining Database Statistics 1008 Identifying Statistics Problems

gpbackup, gprestore, and gpbackup_manager 496 VMware Greenplum v6.17 Documentation VMware, Inc. 26 Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup_manager 0 DD Boost Storage Plugin Performance Factors 926 VMware Greenplum v6.17 Documentation VMware, Inc. 53 System Resources 927 Workload 927 Throughput 927 Contention 927 Optimization 927 Determining Acceptable Performance 928 Baseline Common Causes of Performance Issues 0 Identifying Hardware and Segment Failures 932 Managing Workload 933 Avoiding Contention 933 Maintaining Database Statistics 934 Identifying Statistics Problems

Configuration File Format 563 Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup\_manager 565 DD Boost Storage Plugin Configuration File Format 565 Examples 567 Notes 568 Replicating Defining Database Performance 994 Understanding the Performance Factors 994 System Resources 995 Workload 995 Throughput 995 Contention 995 Optimization 995 Determining Acceptable Performance 995 Baseline Common Causes of Performance Issues 998 Identifying Hardware and Segment Failures 998 Managing Workload 999 Avoiding Contention 999 Maintaining Database Statistics 999 Identifying Statistics Problems

Defining Database Performance 1172 Understanding the Performance Factors 1172 System Resources 1173 Workload 1173 Throughput 1173 Contention 1173 Optimization 1173 Determining Acceptable Performance 1174 Common Causes of Performance Issues 1176 Identifying Hardware and Segment Failures 1176 Managing Workload 1177 Avoiding Contention 1177 Maintaining Database Statistics 1177 Identifying Statistics Problems 1224 Checking System State 1224 Checking Database Activity 1224 Checking for Active Sessions (Workload) 1224 Checking for Locks (Contention) 1225 VMware Greenplum 6 Documentation VMware by Broadcom

Defining Database Performance 1140 Understanding the Performance Factors 1140 System Resources 1141 Workload 1141 Throughput 1141 Contention 1141 Optimization 1141 Determining Acceptable Performance 1142 Common Causes of Performance Issues 1144 Identifying Hardware and Segment Failures 1144 Managing Workload 1145 Avoiding Contention 1145 Maintaining Database Statistics 1145 Identifying Statistics Problems 1192 Checking System State 1192 Checking Database Activity 1192 Checking for Active Sessions (Workload) 1192 Checking for Locks (Contention) 1193 Checking Query Status and System Utilization 1193

Defining Database Performance 1157 Understanding the Performance Factors 1157 System Resources 1158 Workload 1158 Throughput 1158 Contention 1158 Optimization 1158 Determining Acceptable Performance 1159 Common Causes of Performance Issues 1161 Identifying Hardware and Segment Failures 1161 Managing Workload 1162 Avoiding Contention 1162 Maintaining Database Statistics 1162 Identifying Statistics Problems 1207 Checking System State 1207 Checking Database Activity 1207 Checking for Active Sessions (Workload) 1207 Checking for Locks (Contention) 1208 Checking Query Status and System Utilization 1208

Defining Database Performance 978 Understanding the Performance Factors 978 System Resources 979 Workload 979 Throughput 979 Contention 979 Optimization 979 Determining Acceptable Performance 979 Baseline Common Causes of Performance Issues 982 Identifying Hardware and Segment Failures 982 Managing Workload 982 Avoiding Contention 983 Maintaining Database Statistics 983 Identifying Statistics Problems 1021 Checking System State 1021 Checking Database Activity 1021 Checking for Active Sessions (Workload) 1021 Checking for Locks (Contention) 1021 Checking Query Status and System Utilization 1022

Defining Database Performance 1121 Understanding the Performance Factors 1121 System Resources 1122 Workload 1122 Throughput 1122 Contention 1122 Optimization 1122 Determining Acceptable Performance 1122 Hardware and Segment Failures 1125 VMware Tanzu Greenplum 6 Documentation VMware, Inc 51 Managing Workload 1126 Avoiding Contention 1126 Maintaining Database Statistics 1126 Identifying Statistics Problems 1168 Checking System State 1169 Checking Database Activity 1169 Checking for Active Sessions (Workload) 1169 Checking for Locks (Contention) 1169 Checking Query Status and System Utilization 1170