Services (AWS) 148 Virtual Machine Type 148 Compute 149 Memory 149 Network 149 Storage 149 Elastic Block Storage (EBS) 149 Ephemeral 150 AWS Recommendations 150 Coordinator 150 Segments 150 Google Compute Example 3 341 Example 4 342 Example 5 342 Adding Compression in a TYPE Command 343 Choosing Block Size 343 Altering a Table 343 Altering Table Distribution 344 Changing the Distribution Policy Retrieve Session Information 703 VMware Greenplum 7 Documentation VMware by Broadcom 28 Limiting the Number of Concurrently Open Cursors 704 Known Issues and Limitations 704 Additional Documentation 704

Services (AWS) 317 Virtual Machine Type 317 Compute 318 Memory 318 Network 318 Storage 318 Elastic Block Storage (EBS) 318 Ephemeral 319 AWS Recommendations 319 Master 319 Segments 319 Google Compute Greenplum v6.19 Documentation VMware, Inc. 15 OS Memory Configuration 333 Shared Memory Settings 334 Number of Segments per Host 334 Resource Queue Segment Memory Configuration 334 Resource Queue Statement Distributions 339 Local (Co-located) Joins 340 Data Skew 340 Processing Skew 341 Partitioning 341 Number of Partition and Columnar Storage Files 342 Indexes 343 Column Sequence and Byte Alignment 344

Services (AWS) 295 Virtual Machine Type 295 Compute 296 Memory 296 Network 296 Storage 296 Elastic Block Storage (EBS) 296 Ephemeral 297 AWS Recommendations 297 Master 297 VMware Greenplum 6 Documentation Example 3 575 Example 4 575 Example 5 575 Adding Compression in a TYPE Command 576 Choosing Block Size 577 Altering a Table 577 Altering Table Distribution 577 Changing the Distribution Policy Row 994 Example: Using a Variable Number of Arguments 995 Example: Using Default Argument Values 996 Example: Using Polymorphic Data Types 996 Example: Anonymous Block 997 References 998 PL/Python Language

Services (AWS) 282 Virtual Machine Type 282 Compute 282 Memory 282 Network 283 Storage 283 Elastic Block Storage (EBS) 283 Ephemeral 283 AWS Recommendations 284 Master 284 Segments 284 VMware Greenplum Calculating the Greenplum Database Size and ESXi Hosts 328 Determining the RAID Type 328 Determining the Number of Virtual Machines 329 Sizing the Greenplum Virtual Machine 330 Putting It All Together 330 Dell VMware, Inc. 25 Example 4 546 Example 5 546 Adding Compression in a TYPE Command 547 Choosing Block Size 547 Altering a Table 548 Altering Table Distribution 548 Changing the Distribution Policy

Services (AWS) 308 Virtual Machine Type 308 Compute 309 Memory 309 Network 309 Storage 309 Elastic Block Storage (EBS) 309 Ephemeral 310 AWS Recommendations 310 Master 310 Segments 310 Google Compute Configuration 0 I/O Configuration 324 OS Memory Configuration 324 Shared Memory Settings 325 Number of Segments per Host 325 Resource Queue Segment Memory Configuration 325 Resource Queue Statement Distributions 330 Local (Co-located) Joins 331 Data Skew 331 Processing Skew 332 Partitioning 332 Number of Partition and Columnar Storage Files 333 Indexes 334 Column Sequence and Byte Alignment 335

Services (AWS) 264 Virtual Machine Type 264 Compute 264 Memory 264 Network 264 Storage 264 Elastic Block Storage (EBS) 265 Ephemeral 265 AWS Recommendations 265 Master 265 Segments 265 Google Compute Calculating the Greenplum Database Size and ESXi Hosts 310 Determining the RAID Type 310 Determining the Number of Virtual Machines 311 Sizing the Greenplum Virtual Machine 312 Putting It All Together 312 Dell Example 3 569 Example 4 569 Example 5 570 Adding Compression in a TYPE Command 570 Choosing Block Size 571 Altering a Table 571 Altering Table Distribution 571 Changing the Distribution Policy

Services (AWS) 256 Virtual Machine Type 256 Compute 256 Memory 256 Network 256 Storage 256 Elastic Block Storage (EBS) 256 Ephemeral 257 AWS Recommendations 257 Master 257 Segments 257 Google Compute Calculating the Greenplum Database Size and ESXi Hosts 299 Determining the RAID Type 300 Determining the Number of Virtual Machines 300 Sizing the Greenplum Virtual Machine 301 Putting It All Together 302 Dell Example 3 548 Example 4 548 Example 5 549 Adding Compression in a TYPE Command 549 Choosing Block Size 550 Altering a Table 550 Altering Table Distribution 550 Changing the Distribution Policy

Services (AWS) 312 Virtual Machine Type 312 Compute 313 Memory 313 Network 313 Storage 313 Elastic Block Storage (EBS) 313 Ephemeral 314 AWS Recommendations 314 Master 314 Segments 314 Google Compute Configuration 327 I/O Configuration 328 OS Memory Configuration 328 Shared Memory Settings 329 Number of Segments per Host 329 Resource Queue Segment Memory Configuration 329 Resource Queue Statement Processing Skew 336 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 15 Partitioning 336 Number of Partition and Columnar Storage Files 337 Indexes 338 Column Sequence and Byte Alignment 339

Services (AWS) 252 Virtual Machine Type 252 Compute 252 Memory 252 Network 253 Storage 253 Elastic Block Storage (EBS) 253 Ephemeral 253 AWS Recommendations 254 Master 254 Segments 254 Google Compute Calculating the Greenplum Database Size and ESXi Hosts 295 Determining the RAID Type 295 Determining the Number of Virtual Machines 296 Sizing the Greenplum Virtual Machine 297 Putting It All Together 297 Dell Example 3 545 Example 4 545 Example 5 546 Adding Compression in a TYPE Command 546 Choosing Block Size 547 Altering a Table 547 Altering Table Distribution 547 Changing the Distribution Policy

Services (AWS) 229 Virtual Machine Type 229 Compute 229 Memory 229 Network 229 Storage 229 Elastic Block Storage (EBS) 229 Ephemeral 230 AWS Recommendations 230 Master 230 Segments 230 Google Compute Calculating the Greenplum Database Size and ESXi Hosts 268 Determining the RAID Type 268 Determining the Number of Virtual Machines 269 Sizing the Greenplum Virtual Machine 270 Putting It All Together 270 Dell Example 3 465 Example 4 465 Example 5 465 Adding Compression in a TYPE Command 466 Choosing Block Size 467 Altering a Table 467 Altering Table Distribution 467 Changing the Distribution Policy