1 266 Changed Features 267 Resolved Issues 267 Release 6.0.0 269 New Features 269 PostgreSQL Core Features 269 INTERVAL Data Type Handling 269 Additional PostgreSQL Features 270 Zstandard Compression 340 Greenplum Layer 341 High Availability 341 Planning VMware vSphere with Greenplum 342 The Functional Unit 342 Deploying VMware Greenplum to an Existing vSphere Environment 342 Determining the RAID 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 Huge Pages (THP)

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 Huge Pages (THP) Network Performance 216 Validating Disk I/O and Memory Bandwidth 216 To run the disk and stream tests 217 Initializing a Greenplum Database System 217 Overview 217 Initializing Greenplum Database 218 Limit 975 Bypass and Unassign from Resource Groups 975 CPU Limits 976 Assigning CPU Resources by Core 977 Assigning CPU Resources by Percentage 978 Memory Limits 979 Disk I/O Limits 980 Configuring

Inc 9 Changed Features 227 Resolved Issues 228 Release 6.0.0 229 New Features 230 PostgreSQL Core Features 230 INTERVAL Data Type Handling 230 Additional PostgreSQL Features 231 Zstandard Compression 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 Huge Pages (THP) Network Performance 416 Validating Disk I/O and Memory Bandwidth 417 To run the disk and stream tests 417 Initializing a Greenplum Database System 417 Overview 418 Initializing Greenplum Database 418

1 234 Changed Features 235 Resolved Issues 235 Release 6.0.0 237 New Features 237 PostgreSQL Core Features 237 INTERVAL Data Type Handling 237 Additional PostgreSQL Features 238 Zstandard Compression 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 Huge Pages (THP) Network Performance 430 Validating Disk I/O and Memory Bandwidth 431 To run the disk and stream tests 431 Initializing a Greenplum Database System 432 Overview 432 Initializing Greenplum Database 433

1 224 Changed Features 224 Resolved Issues 224 Release 6.0.0 226 New Features 226 PostgreSQL Core Features 227 INTERVAL Data Type Handling 227 Additional PostgreSQL Features 227 Zstandard Compression 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 Huge Pages (THP) Documentation VMware, Inc. 17 Validating Disk I/O and Memory Bandwidth 414 To run the disk and stream tests 414 Initializing a Greenplum Database System 415 Overview 415 Initializing Greenplum Database 415

1 253 Changed Features 253 Resolved Issues 254 Release 6.0.0 255 New Features 256 PostgreSQL Core Features 256 INTERVAL Data Type Handling 256 Additional PostgreSQL Features 257 Zstandard Compression 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 Huge Pages (THP) Network Performance 405 Validating Disk I/O and Memory Bandwidth 406 To run the disk and stream tests 406 Initializing a Greenplum Database System 407 Overview 407 Initializing Greenplum Database 407

1 215 Changed Features 215 Resolved Issues 215 Release 6.0.0 216 New Features 217 PostgreSQL Core Features 217 INTERVAL Data Type Handling 217 Additional PostgreSQL Features 218 Zstandard Compression 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 (THP) 255 IPC Object Network Performance 268 Validating Disk I/O and Memory Bandwidth 269 To run the disk and stream tests 269 Initializing a Greenplum Database System 270 Initializing a Greenplum Database System 0 Overview

1 207 Changed Features 207 Resolved Issues 207 Release 6.0.0 209 New Features 209 PostgreSQL Core Features 209 INTERVAL Data Type Handling 209 Additional PostgreSQL Features 210 Zstandard Compression 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 (THP) 248 IPC Object Network Performance 260 Validating Disk I/O and Memory Bandwidth 261 To run the disk and stream tests 261 Initializing a Greenplum Database System 262 Initializing a Greenplum Database System 0 Overview

Network Performance 194 Validating Disk I/O and Memory Bandwidth 195 To run the disk and stream tests 195 Initializing a Greenplum Database System 195 Initializing a Greenplum Database System 0 Overview Memory Auditor 944 Transaction Concurrency Limit 945 CPU Limits 945 Assigning CPU Resources by Core 946 Assigning CPU Resources by Percentage 947 Elastic mode 947 Ceiling Enforcement mode 948 Memory Greenplum SQL Standard Conformance 1745 VMware Greenplum v6.17 Documentation VMware, Inc. 127 Core SQL Conformance 1745 SQL 1992 Conformance 1746 SQL 1999 Conformance 1746 SQL 2003 Conformance 1747

1 212 Changed Features 212 Resolved Issues 212 Release 6.0.0 213 New Features 214 PostgreSQL Core Features 214 INTERVAL Data Type Handling 214 Additional PostgreSQL Features 215 Zstandard Compression Parameters Settings 247 The hosts File 248 The sysctl.conf File 248 System Resources Limits 251 Core Dump 251 XFS Mount Options 251 Disk I/O Settings 252 Transparent Huge Pages (THP) 253 IPC Object Network Performance 266 Validating Disk I/O and Memory Bandwidth 266 To run the disk and stream tests 267 Initializing a Greenplum Database System 267 Overview 267 Initializing Greenplum Database 268