345 Configuring Resource Groups 346 Low Memory Queries 346 Administrative Utilities and admin_group Concurrency 347 Memory and Resource Management with Resource Queues 347 Memory and Resource Management Instances 386 Best Practices 386 Additional Information 386 Segment Mirroring Configurations 387 Group Mirroring 388 Spread Mirroring 388 Block Mirroring 389 Implementing Block Mirroring 390 Overview Groups 1017 Using Resource Groups 0 Understanding Role and Component Resource Groups 1017 Resource Group Attributes and Limits 1018 Memory Auditor 1019 Transaction Concurrency Limit 1020 CPU Limits 1020

336 Configuring Resource Groups 337 Low Memory Queries 337 Administrative Utilities and admin_group Concurrency 338 VMware Greenplum v6.18 Documentation VMware, Inc. 15 Memory and Resource Management Instances 377 Best Practices 377 Additional Information 377 Segment Mirroring Configurations 378 Group Mirroring 379 Spread Mirroring 379 Block Mirroring 380 Implementing Block Mirroring 381 Overview Groups 1008 Using Resource Groups 0 Understanding Role and Component Resource Groups 1008 Resource Group Attributes and Limits 1009 Memory Auditor 1010 Transaction Concurrency Limit 1011 CPU Limits 1011

341 Configuring Resource Groups 341 Low Memory Queries 341 Administrative Utilities and admin_group Concurrency 342 Memory and Resource Management with Resource Queues 342 Resolving Out of Memory Instances 381 Best Practices 381 Additional Information 381 Segment Mirroring Configurations 382 Group Mirroring 382 Spread Mirroring 383 Block Mirroring 384 Implementing Block Mirroring 385 Overview 1006 Using Resource Groups 1007 Understanding Role and Component Resource Groups 1008 Resource Group Attributes and Limits 1009 Memory Auditor 1010 Transaction Concurrency Limit 1010 CPU Limits 1011

272 Configuring Resource Groups 272 Low Memory Queries 273 Administrative Utilities and admin_group Concurrency 273 Memory and Resource Management with Resource Queues 273 Memory and Resource Management Instances 312 Best Practices 312 Additional Information 312 Segment Mirroring Configurations 313 Group Mirroring 314 Spread Mirroring 314 Block Mirroring 315 Implementing Block Mirroring 316 Overview Groups 942 Using Resource Groups 0 Understanding Role and Component Resource Groups 943 Resource Group Attributes and Limits 944 Memory Auditor 944 Transaction Concurrency Limit 945 CPU Limits 945

1185 Using Resource Groups 1186 Understanding Role and Component Resource Groups 1186 Resource Group Attributes and Limits 1187 Memory Auditor 1188 Transaction Concurrency Limit 1189 CPU Limits 1189 1195 memory_spill_ratio and Low Memory Queries 1195 About Using Reserved Resource Group Memory vs. Using Resource Group Global Shared Memory 1195 Other Memory Considerations 1196 Using VMware Greenplum Resource Group to a Role 1202 Monitoring Resource Group Status 1203 Viewing Resource Group Limits 1203 Viewing Resource Group Query Status and CPU/Memory Usage 1203 Viewing Resource Group CPU/Memory

1153 Using Resource Groups 1154 Understanding Role and Component Resource Groups 1155 Resource Group Attributes and Limits 1156 Memory Auditor 1156 Transaction Concurrency Limit 1157 CPU Limits 1157 1163 memory_spill_ratio and Low Memory Queries 1164 About Using Reserved Resource Group Memory vs. Using Resource Group Global Shared Memory 1164 Other Memory Considerations 1165 Using VMware Greenplum Resource Group to a Role 1170 Monitoring Resource Group Status 1171 Viewing Resource Group Limits 1171 Viewing Resource Group Query Status and CPU/Memory Usage 1171 Viewing Resource Group CPU/Memory

Role and Component Resource Groups 1171 VMware Greenplum 6 Documentation VMware, Inc 51 Resource Group Attributes and Limits 1172 Memory Auditor 1173 Transaction Concurrency Limit 1174 CPU Limits 1174 1179 memory_spill_ratio and Low Memory Queries 1180 About Using Reserved Resource Group Memory vs. Using Resource Group Global Shared Memory 1180 Other Memory Considerations 1181 Using VMware Greenplum Resource Group to a Role 1186 Monitoring Resource Group Status 1187 Viewing Resource Group Limits 1187 Viewing Resource Group Query Status and CPU/Memory Usage 1187 Viewing Resource Group CPU/Memory

interval, float MEDIAN (expression) Example: SELECT departmzent_id, MEDIAN(salary) FROM employees GROUP BY department_id; Can take a two-dimensional array as input. Treats such arrays as matrices. sum(array[]) 1133 Using Resource Groups 1134 Understanding Role and Component Resource Groups 1135 Resource Group Attributes and Limits 1136 Memory Auditor 1136 Transaction Concurrency Limit 1137 CPU Limits 1137 1142 memory_spill_ratio and Low Memory Queries 1143 About Using Reserved Resource Group Memory vs. Using Resource Group Global Shared Memory 1143 Other Memory Considerations 1143 Using VMware Tanzu Greenplum

1128 Using Resource Groups 1129 Understanding Role and Component Resource Groups 1130 Resource Group Attributes and Limits 1131 Memory Auditor 1132 Transaction Concurrency Limit 1132 CPU Limits 1133 1138 memory_spill_ratio and Low Memory Queries 1138 About Using Reserved Resource Group Memory vs. Using Resource Group Global Shared Memory 1138 Other Memory Considerations 1139 Using VMware Tanzu Resource Group to a Role 1144 Monitoring Resource Group Status 1144 Viewing Resource Group Limits 1144 Viewing Resource Group Query Status and CPU/Memory Usage 1145 Viewing Resource Group CPU/Memory

interval, float MEDIAN (expression) Example: SELECT departmzent_id, MEDIAN(salary) FROM employees GROUP BY department_id; Can take a two-dimensional array as input. Treats such arrays as matrices. sum(array[]) Resources 989 Using Resource Groups 990 Understanding Role and Component Resource Groups 991 Resource Group Attributes and Limits 991 Memory Auditor 992 VMware Tanzu Greenplum 6 Documentation VMware, Inc 997 memory_spill_ratio and Low Memory Queries 998 About Using Reserved Resource Group Memory vs. Using Resource Group Global Shared Memory 998 Other Memory Considerations 998 Using VMware Tanzu Greenplum