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 Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 537 Append-Optimized Storage 538 To create a heap table 538 Choosing Row or Column-Oriented

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 Distribution Key Hash Functions 564 Example Custom Hash Operator Class 564 Choosing the Table Storage Model 566 Heap Storage 566 Append-Optimized Storage 567 To create a heap table 567 Choosing Row or Column-Oriented

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 Distribution Key Hash Functions 558 Example Custom Hash Operator Class 559 Choosing the Table Storage Model 561 Heap Storage 561 Append-Optimized Storage 561 To create a heap table 562 Choosing Row or Column-Oriented

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 Distribution Key Hash Functions 538 Example Custom Hash Operator Class 538 Choosing the Table Storage Model 540 Heap Storage 541 Append-Optimized Storage 541 To create a heap table 541 Choosing Row or Column-Oriented Changing the Distribution Policy 550 Redistributing Table Data 551 Altering the Table Storage Model 551 Adding a Compressed Column to Table 551 Inheritance of Compression Settings 552 Dropping a

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 Greenplum Database Best Practices 0 Best Practices Summary 324 Best Practices Summary 0 Data Model 324 Heap vs. Append-Optimized Storage 324 Row vs. Column Oriented Storage 324 Compression 325 Data Types 337 Use Types Consistently 337 Choose Data Types that Use the Least Space 337 Storage Model 337 Heap Storage or Append-Optimized Storage 338 Row or Column Orientation 338 Compression 339

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 Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 538 Append-Optimized Storage 538 To create a heap table 538 Choosing Row or Column-Oriented Changing the Distribution Policy 548 Redistributing Table Data 548 Altering the Table Storage Model 548 Adding a Compressed Column to Table 549 Inheritance of Compression Settings 549 Dropping a

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 Greenplum Database Best Practices 0 Best Practices Summary 315 Best Practices Summary 0 Data Model 315 Heap vs. Append-Optimized Storage 315 Row vs. Column Oriented Storage 315 Compression 316 Data Types 328 Use Types Consistently 328 Choose Data Types that Use the Least Space 328 Storage Model 328 Heap Storage or Append-Optimized Storage 329 Row or Column Orientation 329 Compression 330

Tanzu™ Greenplum® 6.21 Documentation 127 Welcome to Tanzu Greenplum 127 Differences Compared to Open Source Greenplum Database 127 Server Documentation 128 Client Documentation 128 Related Documentation Distribution Key Hash Functions 456 Example Custom Hash Operator Class 456 Choosing the Table Storage Model 458 Heap Storage 458 Append-Optimized Storage 458 VMware Tanzu Greenplum 6 Documentation VMware Changing the Distribution Policy 467 Redistributing Table Data 467 Altering the Table Storage Model 468 Adding a Compressed Column to Table 468 Inheritance of Compression Settings 468 Dropping a

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 Master 317 Segments 317 Greenplum Database Best Practices 318 Best Practices Summary 319 Data Model 319 Heap vs. Append-Optimized Storage 319 Row vs. Column Oriented Storage 319 VMware Tanzu Greenplum Data Types 332 Use Types Consistently 332 Choose Data Types that Use the Least Space 332 Storage Model 332 Heap Storage or Append-Optimized Storage 333 Row or Column Orientation 333 Compression 334

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 Distribution Key Hash Functions 331 Example Custom Hash Operator Class 331 Choosing the Table Storage Model 333 Heap Storage 333 Append-Optimized Storage 334 To create a heap table 334 Choosing Row or Column-Oriented