Asked Questions 1153 CPU 1153 Memory 1153 Concurrency 1154 Using Resource Queues 1154 Resource Queue Example 1156 How Memory Limits Work 1157 statement_mem and Low Memory Queries 1158 How Priorities to a Resource Queue 1164 Removing a Role from a Resource Queue 1165 Modifying Resource Queues 1165 Altering a Resource Queue 1165 Dropping a Resource Queue 1165 Checking Resource Queue Status 1165 Statements and Resource Queue Status 1166 Viewing Resource Queue Statistics 1166 Viewing the Roles Assigned to a Resource Queue 1166 Viewing the Waiting Queries for a Resource Queue 1167 VMware Tanzu Greenplum

Asked Questions 1148 CPU 1148 Memory 1148 Concurrency 1149 Using Resource Queues 1149 Resource Queue Example 1152 How Memory Limits Work 1152 statement_mem and Low Memory Queries 1153 How Priorities to a Resource Queue 1159 Removing a Role from a Resource Queue 1160 Modifying Resource Queues 1160 Altering a Resource Queue 1160 Dropping a Resource Queue 1160 Checking Resource Queue Status 1161 Statements and Resource Queue Status 1161 Viewing Resource Queue Statistics 1161 Viewing the Roles Assigned to a Resource Queue 1162 Viewing the Waiting Queries for a Resource Queue 1162 Clearing a Waiting

Concurrency 1192 Using Resource Queues 1192 VMware Greenplum 6 Documentation VMware, Inc 52 Resource Queue Example 1194 How Memory Limits Work 1195 statement_mem and Low Memory Queries 1196 How Priorities to a Resource Queue 1202 Removing a Role from a Resource Queue 1203 Modifying Resource Queues 1203 Altering a Resource Queue 1203 Dropping a Resource Queue 1204 Checking Resource Queue Status 1204 Statements and Resource Queue Status 1204 Viewing Resource Queue Statistics 1204 Viewing the Roles Assigned to a Resource Queue 1205 Viewing the Waiting Queries for a Resource Queue 1205 Clearing a Waiting

Asked Questions 1006 CPU 1007 Memory 1007 Concurrency 1007 Using Resource Queues 1008 Resource Queue Example 1010 How Memory Limits Work 1010 VMware Tanzu Greenplum 6 Documentation VMware, Inc 51 to a Resource Queue 1017 Removing a Role from a Resource Queue 1017 Modifying Resource Queues 1017 Altering a Resource Queue 1017 Dropping a Resource Queue 1018 Checking Resource Queue Status 1018 Statements and Resource Queue Status 1018 Viewing Resource Queue Statistics 1018 Viewing the Roles Assigned to a Resource Queue 1019 Viewing the Waiting Queries for a Resource Queue 1019 Clearing a Waiting

Asked Questions 1175 CPU 1175 Memory 1175 Concurrency 1176 Using Resource Queues 1176 Resource Queue Example 1179 How Memory Limits Work 1179 statement_mem and Low Memory Queries 1180 How Priorities to a Resource Queue 1187 Removing a Role from a Resource Queue 1188 Modifying Resource Queues 1188 Altering a Resource Queue 1188 Dropping a Resource Queue 1189 Checking Resource Queue Status 1189 Statements and Resource Queue Status 1189 Viewing Resource Queue Statistics 1189 Viewing the Roles Assigned to a Resource Queue 1190 Viewing the Waiting Queries for a Resource Queue 1190 Clearing a Waiting

Asked Questions 1207 CPU 1207 Memory 1207 Concurrency 1208 Using Resource Queues 1208 Resource Queue Example 1211 How Memory Limits Work 1211 statement_mem and Low Memory Queries 1212 How Priorities to a Resource Queue 1219 Removing a Role from a Resource Queue 1220 Modifying Resource Queues 1220 Altering a Resource Queue 1220 Dropping a Resource Queue 1221 Checking Resource Queue Status 1221 Statements and Resource Queue Status 1221 Viewing Resource Queue Statistics 1221 Viewing the Roles Assigned to a Resource Queue 1222 Viewing the Waiting Queries for a Resource Queue 1222 Clearing a Waiting

Append-Optimized Storage 248 Row vs. Column Oriented Storage 248 Compression 249 Distributions 249 Resource Queue Memory Management 249 VMware Greenplum v6.17 Documentation VMware, Inc. 10 Partitioning 251 Indexes 258 Number of Segments per Host 258 Resource Queue Segment Memory Configuration 258 Resource Queue Statement Memory Configuration 260 Resource Queue Spill File Configuration 260 Schema Design 261 CPU 962 Memory 962 Concurrency 963 Using Resource Queues 963 Using Resource Queues 0 Resource Queue Example 966 How Memory Limits Work 966 statement_mem and Low Memory Queries 967 How Priorities

Append-Optimized Storage 324 Row vs. Column Oriented Storage 324 Compression 325 Distributions 325 Resource Queue Memory Management 325 Partitioning 327 Indexes 327 Resource Queues 327 Monitoring and Maintenance 334 Number of Segments per Host 334 Resource Queue Segment Memory Configuration 334 Resource Queue Statement Memory Configuration 335 Resource Queue Spill File Configuration 336 Schema Design 337 1036 Memory 1036 Concurrency 1037 Using Resource Queues 1037 Using Resource Queues 0 Resource Queue Example 1040 How Memory Limits Work 1040 statement_mem and Low Memory Queries 1041 How Priorities

Append-Optimized Storage 315 Row vs. Column Oriented Storage 315 Compression 316 Distributions 316 Resource Queue Memory Management 316 Partitioning 318 Indexes 318 Resource Queues 318 Monitoring and Maintenance 325 Number of Segments per Host 325 Resource Queue Segment Memory Configuration 325 Resource Queue Statement Memory Configuration 326 Resource Queue Spill File Configuration 327 Schema Design 328 1027 Memory 1027 Concurrency 1028 Using Resource Queues 1028 Using Resource Queues 0 Resource Queue Example 1031 How Memory Limits Work 1031 statement_mem and Low Memory Queries 1032 How Priorities

Tanzu Greenplum v6.20 Documentation VMware, Inc. 14 Compression 320 Distributions 320 Resource Queue Memory Management 320 Partitioning 322 Indexes 322 Resource Queues 323 Monitoring and Maintenance 329 Number of Segments per Host 329 Resource Queue Segment Memory Configuration 329 Resource Queue Statement Memory Configuration 330 Resource Queue Spill File Configuration 331 Schema Design 332 Asked Questions 1026 CPU 1026 Memory 1026 Concurrency 1027 Using Resource Queues 1027 Resource Queue Example 1029 How Memory Limits Work 1030 statement_mem and Low Memory Queries 1031 How Priorities