Statistics 334 Analyzing Partitioned Tables 334 Configuring Statistics 335 Statistics Target 335 Automatic Statistics Collection 336 VMware Greenplum on vSphere 338 Overview 338 Getting Started 339 VMware Partition Statistics 778 Running ANALYZE 778 GPORCA and Leaf Partition Statistics 779 Deactivating Automatic Root Partition Statistics Collection 779 Considerations when Using GPORCA 780 GPORCA Features 1199 Procedure 1200 Enabling Resource Groups 1200 Creating Resource Groups 1201 Configuring Automatic Query Termination Based on Memory Usage 1202 Assigning a Resource Group to a Role 1202 Monitoring

Statistics 185 Analyzing Partitioned Tables 185 Configuring Statistics 186 Statistics Target 186 Automatic Statistics Collection 187 Installing and Upgrading Greenplum 189 Estimating Storage Capacity 190 Partition Statistics 573 Running ANALYZE 574 GPORCA and Leaf Partition Statistics 574 Deactivating Automatic Root Partition Statistics Collection 575 Considerations when Using GPORCA 575 GPORCA Features Configuring cgroup v2 983 Enabling Resource Groups 984 Creating Resource Groups 985 Configuring Automatic Query Termination Based on Memory Usage 986 Assigning a Resource Group to a Role 986 Monitoring

Statistics 302 Analyzing Partitioned Tables 302 Configuring Statistics 303 Statistics Target 303 Automatic Statistics Collection 304 VMware Tanzu Greenplum on vSphere 306 Overview 306 Getting Started Partition Statistics 770 Running ANALYZE 770 GPORCA and Leaf Partition Statistics 771 Deactivating Automatic Root Partition Statistics Collection 771 Considerations when Using GPORCA 772 GPORCA Features 1181 Procedure 1184 Enabling Resource Groups 1184 Creating Resource Groups 1185 Configuring Automatic Query Termination Based on Memory Usage 1186 Assigning a Resource Group to a Role 1186 Monitoring

Tanzu Greenplum 6 Documentation VMware, Inc 12 Configuring Statistics 292 Statistics Target 292 Automatic Statistics Collection 293 VMware Tanzu Greenplum on vSphere 295 Supported Platforms 295 Overview Partition Statistics 742 Running ANALYZE 743 GPORCA and Leaf Partition Statistics 744 Deactivating Automatic Root Partition Statistics Collection 744 Considerations when Using GPORCA 744 GPORCA Features Documentation VMware, Inc 52 Enabling Resource Groups 1146 Creating Resource Groups 1147 Configuring Automatic Query Termination Based on Memory Usage 1148 Assigning a Resource Group to a Role 1148 Monitoring

Statistics 287 Analyzing Partitioned Tables 288 Configuring Statistics 288 Statistics Target 288 Automatic Statistics Collection 289 VMware Tanzu Greenplum on vSphere 291 Overview 291 Getting Started Partition Statistics 742 Running ANALYZE 742 GPORCA and Leaf Partition Statistics 743 Deactivating Automatic Root Partition Statistics Collection 743 Considerations when Using GPORCA 743 GPORCA Features 1139 Procedure 1141 Enabling Resource Groups 1142 Creating Resource Groups 1142 Configuring Automatic Query Termination Based on Memory Usage 1143 Assigning a Resource Group to a Role 1144 Monitoring

Statistics 320 Analyzing Partitioned Tables 320 Configuring Statistics 321 Statistics Target 321 Automatic Statistics Collection 322 VMware Greenplum on vSphere 324 Overview 324 Getting Started 325 VMware Partition Statistics 749 Running ANALYZE 749 GPORCA and Leaf Partition Statistics 750 Deactivating Automatic Root Partition Statistics Collection 750 Considerations when Using GPORCA 751 GPORCA Features 1165 Procedure 1168 Enabling Resource Groups 1168 Creating Resource Groups 1169 Configuring Automatic Query Termination Based on Memory Usage 1170 Assigning a Resource Group to a Role 1170 Monitoring

Statistics 260 Analyzing Partitioned Tables 261 Configuring Statistics 261 Statistics Target 261 Automatic Statistics Collection 262 VMware Tanzu Greenplum on vSphere 264 Supported Platforms 264 Overview Partition Statistics 640 Running ANALYZE 640 GPORCA and Leaf Partition Statistics 641 Disabling Automatic Root Partition Statistics Collection 641 Considerations when Using GPORCA 642 GPORCA Features 999 Procedure 1001 Enabling Resource Groups 1001 Creating Resource Groups 1002 Configuring Automatic Query Termination Based on Memory Usage 1002 Assigning a Resource Group to a Role 1003 Monitoring

Statistics Selectively 344 Improving Statistics Quality 345 When to Run ANALYZE 345 Configuring Automatic Statistics Collection 345 Managing Bloat in a Database 346 Managing Bloat in a Database 0 About Partition Statistics 0 Running ANALYZE 859 GPORCA and Leaf Partition Statistics 860 Disabling Automatic Root Partition Statistics Collection 860 Considerations when Using GPORCA 861 Considerations when 1018 Procedure 1020 Enabling Resource Groups 1020 Creating Resource Groups 1021 Configuring Automatic Query Termination Based on Memory Usage 1022 Assigning a Resource Group to a Role 1022 Monitoring

Statistics Selectively 353 Improving Statistics Quality 354 When to Run ANALYZE 354 Configuring Automatic Statistics Collection 354 Managing Bloat in a Database 355 Managing Bloat in a Database 0 About Partition Statistics 0 Running ANALYZE 868 GPORCA and Leaf Partition Statistics 869 Disabling Automatic Root Partition Statistics Collection 869 Considerations when Using GPORCA 870 Considerations when 1027 Procedure 1029 Enabling Resource Groups 1029 Creating Resource Groups 1030 Configuring Automatic Query Termination Based on Memory Usage 1031 Assigning a Resource Group to a Role 1031 Monitoring

name pattern, log_rotation_age = 1d # Automatic rotation of logfiles will log_rotation_size = 0 # Automatic rotation of logfiles will #log_duration = off log_line_prefix 3)减少校验点发生的频率 max_wal_size Maximum size to let the WAL grow to between automatic WAL checkpoints. checkpoint_timeout Maximum time between automatic WAL checkpoints 提高max_wal_size和checkpoint_timeout的值可以减少校验点发生的