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 the Distributed Virtual Switch Settings 351 Creating the Distributed Port Groups 352 Configuring the Distributed Port Groups 352 VMware Greenplum 6 Documentation VMware by Broadcom 17 Principles of 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 495

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 the Distributed Virtual Switch Settings 334 Creating the Distributed Port Groups 335 Configuring the Distributed Port Groups 336 Principles of VMware vSphere Distributed Switch to Uplink Assignment 336 Management 516 Security Best Practices 516 System User (gpadmin) 517 Superusers 517 Login Users 517 Groups 517 Object Privileges 518 Operating System Users and File System 518 Managing Data 522 Defining

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 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 Settings 334 Number of Segments per Host 334 Resource Queue Segment Memory Configuration 334 Resource Queue Statement Memory Configuration 335 Resource Queue Spill File Configuration 336 Schema Design

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 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 Settings 325 Number of Segments per Host 325 Resource Queue Segment Memory Configuration 325 Resource Queue Statement Memory Configuration 326 Resource Queue Spill File Configuration 327 Schema Design

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 the Distributed Virtual Switch Settings 315 Creating the Distributed Port Groups 316 Configuring the Distributed Port Groups 317 Principles of VMware vSphere Distributed Switch to Uplink Assignment 317 Management 540 Security Best Practices 540 System User (gpadmin) 541 Superusers 541 Login Users 541 Groups 541 Object Privileges 542 Operating System Users and File System 542 Managing Data 546 Defining

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 the Distributed Virtual Switch Settings 273 Creating the Distributed Port Groups 273 Configuring the Distributed Port Groups 274 Principles of VMware Vsphere Distributed Switch to Uplink Assignment 274 Management 440 Security Best Practices 440 System User (gpadmin) 441 Superusers 441 Login Users 441 Groups 441 Object Privileges 441 Operating System Users and File System 442 Managing Data 445 Defining

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 the Distributed Virtual Switch Settings 305 Creating the Distributed Port Groups 305 Configuring the Distributed Port Groups 306 Principles of VMware vSphere Distributed Switch to Uplink Assignment 306 Management 520 Security Best Practices 520 System User (gpadmin) 520 Superusers 521 Login Users 521 Groups 521 VMware Tanzu Greenplum 6 Documentation VMware, Inc 21 Object Privileges 521 Operating System

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 the Distributed Virtual Switch Settings 301 Creating the Distributed Port Groups 301 Configuring the Distributed Port Groups 302 Principles of VMware vSphere Distributed Switch to Uplink Assignment 302 Management 517 Security Best Practices 518 System User (gpadmin) 518 Superusers 518 Login Users 519 Groups 519 Object Privileges 519 Operating System Users and File System 519 Managing Data 523 Defining

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 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 Settings 329 Number of Segments per Host 329 Resource Queue Segment Memory Configuration 329 Resource Queue Statement Memory Configuration 330 Resource Queue Spill File Configuration 331 Schema Design

Compression 249 Distributions 249 Resource Queue Memory Management 249 VMware Greenplum v6.17 Documentation VMware, Inc. 10 Partitioning 251 Indexes 251 Resource Queues 251 Monitoring and Maintenance Settings 258 Number of Segments per Host 258 Resource Queue Segment Memory Configuration 258 Resource Queue Statement Memory Configuration 260 Resource Queue Spill File Configuration 260 Schema Design Memory and Resource Management with Resource Groups 270 Memory and Resource Management with Resource Groups 0 Configuring Memory for Greenplum Database 271 Memory Considerations when using Resource Groups