Zstandard Compression Algorithm 271 Relaxed Rules for Specifying Table Distribution Columns 271 Resource Groups Features 271 PL/pgSQL Procedural Language Enhancements 272 Replicated Table Data 272 VMware Functions 478 Backing Up and Restoring a Database 479 Completing the Migration 480 Working With Hash Operator Classes in Greenplum 6 480 Migrating from Open Source Greenplum Database to VMware Greenplum 482 Mount Options 493 Disk I/O Settings 493 Synchronizing System Clocks 493 Configuring and Using Resource Groups 494 Enabling iptables (Optional) 494 How to Enable iptables 494 Example iptables Rules

Zstandard Compression Algorithm 257 Relaxed Rules for Specifying Table Distribution Columns 257 Resource Groups Features 258 PL/pgSQL Procedural Language Enhancements 258 Replicated Table Data 258 Concurrency Functions 459 Backing Up and Restoring a Database 460 Completing the Migration 461 Working With Hash Operator Classes in Greenplum 6 461 Migrating from Open Source Greenplum Database to VMware Greenplum 463 Declaring Distribution Keys 534 Custom Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 537 Append-Optimized Storage 538

Declaring Distribution Keys 330 Custom Distribution Key Hash Functions 331 Example Custom Hash Operator Class 331 Choosing the Table Storage Model 333 Heap Storage 333 Append-Optimized Storage 334 Understanding Index-Only Scans and Covering Indexes 391 BRIN Indexes 394 Index Maintenance 395 Built-in Operator Classes 396 Creating and Managing Views 397 Creating Views 397 Dropping Views 397 Best Practices Expressions 586 Column References 587 Positional Parameters 587 Subscripts 587 Field Selection 588 Operator Invocations 588 Function Calls 589 Aggregate Expressions 589 Limitations of Aggregate Expressions

Zstandard Compression Algorithm 238 Relaxed Rules for Specifying Table Distribution Columns 239 Resource Groups Features 239 PL/pgSQL Procedural Language Enhancements 239 Replicated Table Data 240 Concurrency Functions 484 Backing Up and Restoring a Database 485 Completing the Migration 485 Working With Hash Operator Classes in Greenplum 6 486 Migrating from Open Source Greenplum Database to VMware Greenplum 487 Declaring Distribution Keys 558 Custom Distribution Key Hash Functions 558 Example Custom Hash Operator Class 559 Choosing the Table Storage Model 561 Heap Storage 561 Append-Optimized Storage 561

Zstandard Compression Algorithm 231 Relaxed Rules for Specifying Table Distribution Columns 231 Resource Groups Features 232 PL/pgSQL Procedural Language Enhancements 232 Replicated Table Data 232 Concurrency Functions 467 Backing Up and Restoring a Database 468 Completing the Migration 468 Working With Hash Operator Classes in Greenplum 6 469 Enabling iptables (Optional) 470 How to Enable iptables 471 Example Declaring Distribution Keys 537 Custom Distribution Key Hash Functions 538 Example Custom Hash Operator Class 538 Choosing the Table Storage Model 540 Heap Storage 541 Append-Optimized Storage 541

Zstandard Compression Algorithm 207 Relaxed Rules for Specifying Table Distribution Columns 207 Resource Groups Features 207 PL/pgSQL Procedural Language Enhancements 208 Replicated Table Data 208 Concurrency Functions 392 Backing Up and Restoring a Database 393 Completing the Migration 394 Working With Hash Operator Classes in Greenplum 6 394 Enabling iptables (Optional) 396 How to Enable iptables 396 Example Declaring Distribution Keys 455 Custom Distribution Key Hash Functions 456 Example Custom Hash Operator Class 456 Choosing the Table Storage Model 458 Heap Storage 458 Append-Optimized Storage 458

Zstandard Compression Algorithm 228 Relaxed Rules for Specifying Table Distribution Columns 228 Resource Groups Features 229 PL/pgSQL Procedural Language Enhancements 229 Replicated Table Data 229 Concurrency Functions 464 Backing Up and Restoring a Database 465 Completing the Migration 466 Working With Hash Operator Classes in Greenplum 6 466 Enabling iptables (Optional) 468 How to Enable iptables 468 Example Declaring Distribution Keys 535 Custom Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 538 Append-Optimized Storage 538

Specifying Table Distribution Columns 218 VMware Greenplum v6.19 Documentation VMware, Inc. 8 Resource Groups Features 219 PL/pgSQL Procedural Language Enhancements 219 Replicated Table Data 220 Concurrency Upgrade 301 Backing Up and Restoring a Database 305 Completing the Migration 306 Working With Hash Operator Classes in Greenplum 6 307 Enabling iptables (Optional) 308 Enabling iptables (Optional) 0 How Column Oriented Storage 324 Compression 325 Distributions 325 Resource Queue Memory Management 325 Partitioning 327 Indexes 327 Resource Queues 327 Monitoring and Maintenance 328 ANALYZE 328 Vacuum

Zstandard Compression Algorithm 210 Relaxed Rules for Specifying Table Distribution Columns 210 Resource Groups Features 211 PL/pgSQL Procedural Language Enhancements 211 Replicated Table Data 212 Concurrency Upgrade 292 Backing Up and Restoring a Database 296 Completing the Migration 297 Working With Hash Operator Classes in Greenplum 6 297 Enabling iptables (Optional) 299 Enabling iptables (Optional) 0 How Column Oriented Storage 315 Compression 316 Distributions 316 Resource Queue Memory Management 316 Partitioning 318 Indexes 318 Resource Queues 318 Monitoring and Maintenance 319 ANALYZE 319 Vacuum

Zstandard Compression Algorithm 215 Relaxed Rules for Specifying Table Distribution Columns 215 Resource Groups Features 216 PL/pgSQL Procedural Language Enhancements 216 Replicated Table Data 217 Concurrency Backup 297 Backing Up and Restoring a Database 300 Completing the Migration 301 Working With Hash Operator Classes in Greenplum 6 301 Enabling iptables (Optional) 303 How to Enable iptables 303 Example Documentation VMware, Inc. 14 Compression 320 Distributions 320 Resource Queue Memory Management 320 Partitioning 322 Indexes 322 Resource Queues 323 Monitoring and Maintenance 323 ANALYZE 323 Vacuum