Overview 0 Planning Greenplum System Expansion 588 VMware Greenplum v6.18 Documentation VMware, Inc. 33 Planning Greenplum System Expansion 0 System Expansion Checklist 589 Planning New Hardware Hardware Platforms 590 Planning New Segment Initialization 590 Planning Mirror Segments 591 Increasing Segments Per Host 591 About the Expansion Schema 591 Planning Table Redistribution 592 Managing Redistribution Segments 600 To run gpexpand with an input file 600 Monitoring the Cluster Expansion State 600 Rolling Back a Failed Expansion Setup 600 VMware Greenplum v6.18 Documentation VMware, Inc. 34 Redistributing

Overview 0 Planning Greenplum System Expansion 597 VMware Greenplum v6.19 Documentation VMware, Inc. 34 Planning Greenplum System Expansion 0 System Expansion Checklist 598 Planning New Hardware Hardware Platforms 599 Planning New Segment Initialization 599 Planning Mirror Segments 600 Increasing Segments Per Host 600 About the Expansion Schema 600 Planning Table Redistribution 601 Managing Redistribution Segments 609 To run gpexpand with an input file 609 Monitoring the Cluster Expansion State 609 Rolling Back a Failed Expansion Setup 609 VMware Greenplum v6.19 Documentation VMware, Inc. 35 Redistributing

Infrastructure Layer 340 Virtual Machine Cluster Layer 340 Greenplum Layer 341 High Availability 341 Planning VMware vSphere with Greenplum 342 The Functional Unit 342 Deploying VMware Greenplum to an Existing Existing vSphere Environment 342 Determining the RAID Type 343 vSAN ESA 343 vSAN OSA 343 Planning for a Deployment 343 Single-Tier Architecture 344 Deployment Examples 344 10 TiB Database 344 100 Greenplum 6 Documentation VMware by Broadcom 19 Appendix: Grace Period for a Downed Segment 393 Planning Downtime for Maintenance 393 Bringing the ESXi Host Down 394 Bringing the ESXi Host Back Up 394

Expansion Overview 585 Planning Greenplum System Expansion 588 System Expansion Checklist 589 Planning New Hardware Platforms 590 Planning New Segment Initialization 590 Planning Mirror Segments 591 Increasing Segments Per Host 591 About the Expansion Schema 591 Planning Table Redistribution 592 Managing Redistribution in Large-Scale Greenplum Systems 592 Table Redistribution Methods 592 Systems Segments 599 To run gpexpand with an input file 599 Monitoring the Cluster Expansion State 600 Rolling Back a Failed Expansion Setup 600 Redistributing Tables 600 Ranking Tables for Redistribution 601

Overview 0 Planning Greenplum System Expansion 520 Planning Greenplum System Expansion 0 VMware Greenplum v6.17 Documentation VMware, Inc. 29 System Expansion Checklist 521 Planning New Hardware Hardware Platforms 522 Planning New Segment Initialization 522 Planning Mirror Segments 523 Increasing Segments Per Host 523 About the Expansion Schema 523 Planning Table Redistribution 524 Managing Redistribution Segments 532 To run gpexpand with an input file 532 Monitoring the Cluster Expansion State 532 Rolling Back a Failed Expansion Setup 532 Redistributing Tables 533 VMware Greenplum v6.17 Documentation

Machine Cluster Layer 308 Greenplum Layer 309 VMware Greenplum 6 Documentation VMware, Inc 13 Planning VMware vSphere with Greenplum 309 Calculating the Greenplum Database Size and ESXi Hosts 310 Determining Recovery 399 Best Practices for Greenplum HA 399 Appendix: Grace Period for a Downed Segment 399 Planning Downtime for Maintenance 400 Bringing the ESXi Host Down 400 Bringing the ESXi Host Back Up 400 gpextprotocal.c 757 Querying Data 762 About Greenplum Query Processing 763 Understanding Query Planning and Dispatch 763 Understanding Greenplum Query Plans 764 Understanding Parallel Query Execution

Provider Layer 297 Infrastructure Layer 297 Virtual Machine Cluster Layer 298 Greenplum Layer 298 Planning VMware vSphere with Greenplum 299 Calculating the Greenplum Database Size and ESXi Hosts 299 Determining Recovery 388 Best Practices for Greenplum HA 388 Appendix: Grace Period for a Downed Segment 389 Planning Downtime for Maintenance 389 Bringing the ESXi Host Down 389 Bringing the ESXi Host Back Up 390 gpextprotocal.c 730 Querying Data 735 About Greenplum Query Processing 736 Understanding Query Planning and Dispatch 736 Understanding Greenplum Query Plans 737 Understanding Parallel Query Execution

Provider Layer 293 Infrastructure Layer 293 Virtual Machine Cluster Layer 293 Greenplum Layer 294 Planning VMware vSphere with Greenplum 294 Calculating the Greenplum Database Size and ESXi Hosts 295 Determining Recovery 385 Best Practices for Greenplum HA 385 Appendix: Grace Period for a Downed Segment 386 Planning Downtime for Maintenance 386 Bringing the ESXi Host Down 386 Bringing the ESXi Host Back Up 387 gpextprotocal.c 729 Querying Data 734 About Greenplum Query Processing 735 Understanding Query Planning and Dispatch 735 Understanding Greenplum Query Plans 736 Understanding Parallel Query Execution

Provider Layer 326 Infrastructure Layer 326 Virtual Machine Cluster Layer 326 Greenplum Layer 327 Planning VMware vSphere with Greenplum 327 Calculating the Greenplum Database Size and ESXi Hosts 328 Determining Recovery 370 Best Practices for Greenplum HA 371 Appendix: Grace Period for a Downed Segment 371 Planning Downtime for Maintenance 371 Bringing the ESXi Host Down 372 Bringing the ESXi Host Back Up 372 gpextprotocal.c 736 Querying Data 741 About Greenplum Query Processing 742 Understanding Query Planning and Dispatch 742 Understanding Greenplum Query Plans 744 Understanding Parallel Query Execution

Provider Layer 266 Infrastructure Layer 266 Virtual Machine Cluster Layer 266 Greenplum Layer 267 Planning VMware vSphere with Greenplum 268 Calculating the Greenplum Database Size and ESXi Hosts 268 Determining Recovery 326 Best Practices for Greenplum HA 326 Appendix: Grace Period for a Downed Segment 327 Planning Downtime for Maintenance 327 Bringing the ESXi Host Down 327 Bringing the ESXi Host Back Up 328 gpextprotocal.c 629 Querying Data 633 About Greenplum Query Processing 634 Understanding Query Planning and Dispatch 634 Understanding Greenplum Query Plans 635 Understanding Parallel Query Execution