Core Features 217 INTERVAL Data Type Handling 217 Additional PostgreSQL Features 218 Zstandard Compression Algorithm 218 Relaxed Rules for Specifying Table Distribution Columns 218 VMware Greenplum v6 Practices Summary 324 Best Practices Summary 0 Data Model 324 Heap vs. Append-Optimized Storage 324 Row vs. Column Oriented Storage 324 Compression 325 Distributions 325 Resource Queue Memory Management 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 Distributions 339 Local (Co-located) Joins 340

Core Features 209 INTERVAL Data Type Handling 209 Additional PostgreSQL Features 210 Zstandard Compression Algorithm 210 Relaxed Rules for Specifying Table Distribution Columns 210 Resource Groups Features Practices Summary 315 Best Practices Summary 0 Data Model 315 Heap vs. Append-Optimized Storage 315 Row vs. Column Oriented Storage 315 Compression 316 Distributions 316 Resource Queue Memory Management 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 Distributions 330 Local (Co-located) Joins 331

Core Features 269 INTERVAL Data Type Handling 269 Additional PostgreSQL Features 270 Zstandard Compression Algorithm 271 Relaxed Rules for Specifying Table Distribution Columns 271 Resource Groups Features Storage Model 566 Heap Storage 566 Append-Optimized Storage 567 To create a heap table 567 Choosing Row or Column-Oriented Storage 567 To create a column-oriented table 568 Using Compression (Append-Optimized Checking the Compression and Distribution of an Append-Optimized Table 570 Support for Run-length Encoding 571 VMware Greenplum 6 Documentation VMware by Broadcom 27 Adding Column-level Compression 572 Default

Core Features 230 INTERVAL Data Type Handling 230 Additional PostgreSQL Features 231 Zstandard Compression Algorithm 231 Relaxed Rules for Specifying Table Distribution Columns 231 Resource Groups Features Storage Model 540 Heap Storage 541 Append-Optimized Storage 541 To create a heap table 541 Choosing Row or Column-Oriented Storage 541 To create a column-oriented table 542 Using Compression (Append-Optimized the Compression and Distribution of an Append-Optimized Table 544 Support for Run-length Encoding 545 Adding Column-level Compression 545 Default Compression Values 547 Precedence of Compression Settings

Core Features 206 INTERVAL Data Type Handling 206 Additional PostgreSQL Features 206 Zstandard Compression Algorithm 207 Relaxed Rules for Specifying Table Distribution Columns 207 Resource Groups Features 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 459 To create a column-oriented table 460 Using Compression (Append-Optimized Tables Only) 460 To create a compressed table 461 Checking the Compression and Distribution of an Append-Optimized Table 461

Core Features 256 INTERVAL Data Type Handling 256 Additional PostgreSQL Features 257 Zstandard Compression Algorithm 257 Relaxed Rules for Specifying Table Distribution Columns 257 Resource Groups Features Storage Model 537 Heap Storage 537 Append-Optimized Storage 538 To create a heap table 538 Choosing Row or Column-Oriented Storage 538 To create a column-oriented table 539 Using Compression (Append-Optimized the Compression and Distribution of an Append-Optimized Table 541 Support for Run-length Encoding 542 Adding Column-level Compression 543 Default Compression Values 544 Precedence of Compression Settings

Core Features 214 INTERVAL Data Type Handling 214 Additional PostgreSQL Features 215 Zstandard Compression Algorithm 215 Relaxed Rules for Specifying Table Distribution Columns 215 Resource Groups Features Practices Summary 319 Data Model 319 Heap vs. Append-Optimized Storage 319 Row vs. Column Oriented Storage 319 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 14 Compression 320 Distributions 320 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 Distributions 334 Local (Co-located) Joins 335

Core Features 227 INTERVAL Data Type Handling 227 Additional PostgreSQL Features 227 Zstandard Compression Algorithm 228 Relaxed Rules for Specifying Table Distribution Columns 228 Resource Groups Features Storage Model 537 Heap Storage 538 Append-Optimized Storage 538 To create a heap table 538 Choosing Row or Column-Oriented Storage 539 To create a column-oriented table 540 Using Compression (Append-Optimized compressed table 541 Checking the Compression and Distribution of an Append-Optimized Table 541 Support for Run-length Encoding 542 Adding Column-level Compression 542 VMware Tanzu Greenplum 6 Documentation

Core Features 237 INTERVAL Data Type Handling 237 Additional PostgreSQL Features 238 Zstandard Compression Algorithm 238 Relaxed Rules for Specifying Table Distribution Columns 239 Resource Groups Features 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 Greenplum 6 Documentation VMware, Inc 23 Using Compression (Append-Optimized Tables Only) 563 To create a compressed table 565 Checking the Compression and Distribution of an Append-Optimized Table 565

Practices Summary 248 Best Practices Summary 0 Data Model 248 Heap vs. Append-Optimized Storage 248 Row vs. Column Oriented Storage 248 Compression 249 Distributions 249 Resource Queue Memory Management Choose Data Types that Use the Least Space 261 Storage Model 261 Heap Storage or Append-Optimized Storage 262 Row or Column Orientation 262 Compression 263 Distributions 263 Local (Co-located) Joins 264 Configuration Parameter Categories 442 Configuration Parameter Categories 0 Enabling Compression 442 Enabling Compression 0 Configuring Proxies for the Greenplum Interconnect 443 Configuring Proxies for