Tanzu™ Greenplum® 6.19 Documentation 140 Welcome to Tanzu Greenplum 6 140 Differences Compared to Open Source Greenplum Database 140 Server Documentation 141 Client Documentation 141 Related Documentation Statement Memory Configuration 335 Resource Queue Spill File Configuration 336 Schema Design 337 Schema Design 0 Data Types 337 Use Types Consistently 337 Choose Data Types that Use the Least Space Partition Strategy 758 Troubleshooting Selective Partition Scanning 759 Viewing Your Partition Design 759 Maintaining Partitioned Tables 760 Adding a Partition 761 Renaming a Partition 761 Adding

Tanzu™ Greenplum® 6.18 Documentation 139 Welcome to Tanzu Greenplum 6 139 Differences Compared to Open Source Greenplum Database 139 Server Documentation 140 Client Documentation 140 Related Documentation Statement Memory Configuration 326 Resource Queue Spill File Configuration 327 Schema Design 328 Schema Design 0 Data Types 328 Use Types Consistently 328 Choose Data Types that Use the Least Space Partition Strategy 749 Troubleshooting Selective Partition Scanning 750 Viewing Your Partition Design 750 Maintaining Partitioned Tables 751 Adding a Partition 752 Renaming a Partition 752 Adding

Tanzu™ Greenplum® 6.20 Documentation 131 Welcome to Tanzu Greenplum 6 131 Differences Compared to Open Source Greenplum Database 131 Server Documentation 132 Client Documentation 132 Related Documentation Resource Queue Statement Memory Configuration 330 Resource Queue Spill File Configuration 331 Schema Design 332 Data Types 332 Use Types Consistently 332 Choose Data Types that Use the Least Space 332 Partition Strategy 748 Troubleshooting Selective Partition Scanning 748 Viewing Your Partition Design 748 Maintaining Partitioned Tables 749 Adding a Partition 750 VMware Tanzu Greenplum v6.20 Documentation

Contents VMware Greenplum 6 Documentation 140 Welcome to VMware Greenplum 140 Differences Compared to Open Source Greenplum Database 140 Server Documentation 141 Client Documentation 141 Related Documentation Completing the Migration 480 Working With Hash Operator Classes in Greenplum 6 480 Migrating from Open Source Greenplum Database to VMware Greenplum 482 Prerequisites 482 Procedure 482 Migrating VMware Partition Strategy 587 Troubleshooting Selective Partition Scanning 588 Viewing Your Partition Design 588 Maintaining Partitioned Tables 588 Adding a Partition 589 VMware Greenplum 6 Documentation

VMware Greenplum 6.25 Documentation 136 Welcome to VMware Greenplum 136 Differences Compared to Open Source Greenplum Database 136 Server Documentation 137 Client Documentation 137 Related Documentation Completing the Migration 461 Working With Hash Operator Classes in Greenplum 6 461 Migrating from Open Source Greenplum Database to VMware Greenplum 463 Prerequisites 463 Procedure 463 VMware Greenplum Partition Strategy 558 Troubleshooting Selective Partition Scanning 559 Viewing Your Partition Design 559 Maintaining Partitioned Tables 559 Adding a Partition 560 Renaming a Partition 561 Adding

Tanzu™ Greenplum® 6.23 Documentation 130 Welcome to Tanzu Greenplum 130 Differences Compared to Open Source Greenplum Database 130 Server Documentation 131 Client Documentation 131 Related Documentation Completing the Migration 485 Working With Hash Operator Classes in Greenplum 6 486 Migrating from Open Source Greenplum Database to VMware Greenplum 487 Prerequisites 488 Procedure 488 Enabling iptables Partition Strategy 581 Troubleshooting Selective Partition Scanning 582 Viewing Your Partition Design 582 VMware Greenplum 6 Documentation VMware, Inc 24 Maintaining Partitioned Tables 583 Adding

152 Migrating Data to Greenplum 6 154 Known Issues and Limitations 154 Differences Compared to Open Source Greenplum Database 160 Installing and Upgrading Greenplum 161 VMware Greenplum v6.17 Documentation Statement Memory Configuration 260 Resource Queue Spill File Configuration 260 Schema Design 261 Schema Design 0 Data Types 261 Use Types Consistently 261 Choose Data Types that Use the Least Space Partition Strategy 681 Troubleshooting Selective Partition Scanning 682 Viewing Your Partition Design 682 Maintaining Partitioned Tables 683 Adding a Partition 684 Renaming a Partition 684 Adding

Tanzu™ Greenplum® 6.23 Documentation 130 Welcome to Tanzu Greenplum 130 Differences Compared to Open Source Greenplum Database 130 Server Documentation 131 Client Documentation 131 Related Documentation Partition Strategy 560 Troubleshooting Selective Partition Scanning 561 Viewing Your Partition Design 561 Maintaining Partitioned Tables 561 Adding a Partition 562 Renaming a Partition 563 Adding 1127 Tuning Statistics Collection 1127 Optimizing Data Distribution 1127 Optimizing Your Database Design 1127 Greenplum Database Maximum Limits 1128 Greenplum Database Memory Overview 1128 Segment Host

Tanzu™ Greenplum® 6.22 Documentation 131 Welcome to Tanzu Greenplum 131 Differences Compared to Open Source Greenplum Database 131 Server Documentation 132 Client Documentation 132 Related Documentation Partition Strategy 557 Troubleshooting Selective Partition Scanning 558 Viewing Your Partition Design 558 Maintaining Partitioned Tables 559 Adding a Partition 559 Renaming a Partition 560 VMware 1122 Tuning Statistics Collection 1122 Optimizing Data Distribution 1122 Optimizing Your Database Design 1123 Greenplum Database Maximum Limits 1123 Greenplum Database Memory Overview 1123 Segment Host

VMware Greenplum® 7 Documentation 129 Welcome to VMware Greenplum 7 129 Differences Compared to Open Source Greenplum Database 129 Server Documentation 130 Client Documentation 130 Related Documentation 257 Composing a Similar View in Greenplum 7 258 pg_stat_partition_operations 258 Migrating from Open Source Greenplum Database to VMware Greenplum 259 Prerequisites 259 Procedure 259 Enabling iptables Partition Strategy 356 Troubleshooting Selective Partition Scanning 357 About Viewing Your Partition Design 357 Viewing a Classic Syntax Sub-Partition Template 358 Constructing a pg_partitions-Equivalent