194 Recommended OS Parameters Settings 195 The hosts File 195 The sysctl.conf File 196 System Resources Limits 199 Core Dump 199 XFS Mount Options 199 Disk I/O Settings 200 Networking 202 Transparent Performance 959 Defining Database Performance 959 Understanding the Performance Factors 959 System Resources 960 Workload 960 Throughput 960 VMware Greenplum 7 Documentation VMware by Broadcom 42 Contention Configuring Greenplum Database Memory 969 Example Memory Configuration Calculations 969 Managing Resources 970 About Changes to Resource Groups in Greenplum 7 971 Changes to Resource Groups Attributes

Installation 382 Getting the Greenplum Database Cluster Connection Information 383 Additional Resources 383 Installing the Greenplum High Availability Service 383 Prerequisites 383 Installing the Greenplum 402 Recommended OS Parameters Settings 402 The hosts File 403 The sysctl.conf File 403 System Resources Limits 406 Core Dump 407 XFS Mount Options 407 Disk I/O Settings 407 Networking 410 Transparent PL/Container 952 PL/Container Resource Management 952 Using Resource Groups to Manage PL/Container Resources 953 Configuring Resource Groups for PL/Container 954 Notes 955 PL/Container Function Limitations

Greenplum Database to a local machine 346 Deploying the Greenplum Database Template OVA 346 Modifying Resources 347 Validating the Virtual Machine Template 348 Provisioning the Virtual Machines 348 Monitoring 409 Recommended OS Parameters Settings 410 The hosts File 411 The sysctl.conf File 411 System Resources Limits 414 Core Dump 414 XFS Mount Options 415 Disk I/O Settings 415 Networking 417 Transparent PL/Container 941 PL/Container Resource Management 942 Using Resource Groups to Manage PL/Container Resources 942 Configuring Resource Groups for PL/Container 943 Notes 944 PL/Container Function Limitations

Template 364 Importing the Base Template as a Virtual Machine 364 Configuring Base Virtual Machine Resources 364 Deploying Base Virtual Machine 365 Deploying the Greenplum Database Cluster 366 Validating 383 Recommended OS Parameters Settings 384 The hosts File 385 The sysctl.conf File 385 System Resources Limits 388 Core Dump 389 XFS Mount Options 389 Disk I/O Settings 389 Networking 391 Transparent PL/Container 923 PL/Container Resource Management 923 Using Resource Groups to Manage PL/Container Resources 923 Configuring Resource Groups for PL/Container 924 Notes 926 PL/Container Function Limitations

Greenplum Database to a local machine 336 Deploying the Greenplum Database Template OVA 336 Modifying Resources 337 VMware Tanzu Greenplum 6 Documentation VMware, Inc 14 Validating the Virtual Machine Template 396 Recommended OS Parameters Settings 397 The hosts File 398 The sysctl.conf File 398 System Resources Limits 401 Core Dump 401 XFS Mount Options 401 Disk I/O Settings 402 Networking 404 Transparent PL/Container 912 PL/Container Resource Management 912 Using Resource Groups to Manage PL/Container Resources 912 Configuring Resource Groups for PL/Container 914 Notes 915 PL/Container Function Limitations

Greenplum Database to a local machine 332 Deploying the Greenplum Database Template OVA 332 Modifying Resources 333 Validating the Virtual Machine Template 334 Provisioning the Virtual Machines 334 Monitoring 393 Recommended OS Parameters Settings 394 The hosts File 395 The sysctl.conf File 395 System Resources Limits 398 Core Dump 398 XFS Mount Options 398 Disk I/O Settings 399 Networking 401 Transparent PL/Container 910 PL/Container Resource Management 910 Using Resource Groups to Manage PL/Container Resources 911 Configuring Resource Groups for PL/Container 912 Notes 913 PL/Container Functions 913 Limitations

Greenplum Database to a local machine 300 Deploying the Greenplum Database Template OVA 301 Modifying Resources 301 Validating the Virtual Machine Template 302 Provisioning the Virtual Machines 302 Monitoring 333 Recommended OS Parameters Settings 334 The hosts File 335 The sysctl.conf File 335 System Resources Limits 337 Core Dump 338 XFS Mount Options 338 Disk I/O Settings 338 Networking 340 Transparent VMware Tanzu Greenplum 6 Documentation VMware, Inc 38 Using Resource Groups to Manage PL/Container Resources 795 Configuring Resource Groups for PL/Container 797 Notes 798 PL/Container Functions 798 Limitations

241 Recommended OS Parameters Settings 242 The hosts File 243 The sysctl.conf File 243 System Resources Limits 245 Core Dump 246 XFS Mount Options 246 Disk I/O Settings 247 Transparent Huge Pages Understanding the Performance Factors 994 VMware Greenplum v6.18 Documentation VMware, Inc. 57 System Resources 995 Workload 995 Throughput 995 Contention 995 Optimization 995 Determining Acceptable Performance Example Memory Configuration Calculations 1005 Managing Resources 1006 VMware Greenplum v6.18 Documentation VMware, Inc. 58 Managing Resources 0 Using Resource Groups 1008 Using Resource Groups 0

248 Recommended OS Parameters Settings 249 The hosts File 250 The sysctl.conf File 250 System Resources Limits 252 Core Dump 253 XFS Mount Options 253 Disk I/O Settings 254 Transparent Huge Pages Understanding the Performance Factors 1003 VMware Greenplum v6.19 Documentation VMware, Inc. 58 System Resources 1004 Workload 1004 Throughput 1004 Contention 1004 Optimization 1004 Determining Acceptable Example Memory Configuration Calculations 1014 Managing Resources 1015 VMware Greenplum v6.19 Documentation VMware, Inc. 59 Managing Resources 0 Using Resource Groups 1017 Using Resource Groups 0

175 Recommended OS Parameters Settings 176 The hosts File 177 The sysctl.conf File 177 System Resources Limits 179 XFS Mount Options 180 Disk I/O Settings 180 Transparent Huge Pages (THP) 182 IPC Understanding the Performance Factors 926 VMware Greenplum v6.17 Documentation VMware, Inc. 53 System Resources 927 Workload 927 Throughput 927 Contention 927 Optimization 927 Determining Acceptable Performance Example Memory Configuration Calculations 939 Managing Resources 941 VMware Greenplum v6.17 Documentation VMware, Inc. 54 Managing Resources 0 Using Resource Groups 942 Using Resource Groups 0 Understanding