Software 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 Huge Pages (THP) 255 IPC Object Removal 256 SSH Connection Threshold 256 Synchronizing System Clocks 258 To configure NTP 258 Creating the Greenplum Administrative User 259 Next Steps 260 Installing 269 To run the disk and stream tests 269 Initializing a Greenplum Database System 270 Initializing a Greenplum Database System 0 Overview 270 Initializing Greenplum Database 271 Creating the Initialization

Deprecated Features 282 Known Issues and Limitations 283 Platform Requirements 286 Operating System Requirements 286 Software Dependencies 287 Java 290 VMware Greenplum Tools and Extensions Compatibility Hadoop Distributions 294 VMware vSphere Requirements 294 Public Cloud Requirements 295 Operating System 295 Storage 295 Amazon Web Services (AWS) 295 Virtual Machine Type 295 Compute 296 Memory 296 Redundancy 329 About Database Statistics in Greenplum Database 329 System Statistics 330 Table Size 330 The pg_statistic System Table and pg_stats View 330 Sampling 334 Updating Statistics 334 Analyzing

Software 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 Huge Pages (THP) 248 IPC Object Removal 249 SSH Connection Threshold 249 Synchronizing System Clocks 251 To configure NTP 251 Creating the Greenplum Administrative User 252 Next Steps 253 Installing 261 To run the disk and stream tests 261 Initializing a Greenplum Database System 262 Initializing a Greenplum Database System 0 Overview 262 Initializing Greenplum Database 262 Creating the Initialization

Greenplum Command Center 281 Hadoop Distributions 281 Public Cloud Requirements 281 Operating System 281 Storage 282 Security 282 Amazon Web Services (AWS) 282 Virtual Machine Type 282 Compute Redundancy 315 About Database Statistics in Greenplum Database 315 System Statistics 316 Table Size 316 The pg_statistic System Table and pg_stats View 316 Sampling 320 Updating Statistics 320 Analyzing 334 Verifying 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

Greenplum Command Center 263 Hadoop Distributions 263 Public Cloud Requirements 263 Operating System 263 Storage 263 Security 264 Amazon Web Services (AWS) 264 Virtual Machine Type 264 Compute Redundancy 297 About Database Statistics in Greenplum Database 297 System Statistics 298 Table Size 298 The pg_statistic System Table and pg_stats View 298 Sampling 302 Updating Statistics 302 Analyzing 315 Verifying 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

Inc 10 Hadoop Distributions 255 Greenplum Database Cloud Technical Recommendations 255 Operating System 255 Storage 255 Security 256 Amazon Web Services (AWS) 256 Virtual Machine Type 256 Compute Redundancy 286 About Database Statistics in Greenplum Database 286 System Statistics 287 Table Size 287 The pg_statistic System Table and pg_stats View 287 Sampling 291 Updating Statistics 291 Analyzing 304 Verifying 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

228 Hadoop Distributions 228 Greenplum Database Cloud Technical Recommendations 228 Operating System 228 Storage 228 Security 229 Amazon Web Services (AWS) 229 Virtual Machine Type 229 Compute Redundancy 256 About Database Statistics in Greenplum Database 256 System Statistics 257 Table Size 257 The pg_statistic System Table and pg_stats View 257 Sampling 260 Updating Statistics 260 Analyzing 272 Verifying 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

Software 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) VMware Greenplum v6.17 Documentation VMware, Inc. 5 SSH Connection Threshold 183 Synchronizing System Clocks 184 To configure NTP 185 Creating the Greenplum Administrative User 185 Next Steps 187 195 To run the disk and stream tests 195 Initializing a Greenplum Database System 195 Initializing a Greenplum Database System 0 Overview 196 Initializing Greenplum Database 196 Creating the Initialization

251 Hadoop Distributions 251 Greenplum Database Cloud Technical Recommendations 251 Operating System 251 Storage 252 Security 252 Amazon Web Services (AWS) 252 Virtual Machine Type 252 Compute Redundancy 282 About Database Statistics in Greenplum Database 283 System Statistics 283 Table Size 283 The pg_statistic System Table and pg_stats View 284 Sampling 287 Updating Statistics 287 Analyzing 300 Verifying 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

Software 246 Recommended OS 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 Huge Pages (THP) 253 IPC Object Removal 254 SSH Connection Threshold 254 Synchronizing System Clocks 256 To configure NTP 256 Creating the Greenplum Administrative User 256 VMware Tanzu Greenplum and Memory Bandwidth 266 To run the disk and stream tests 267 Initializing a Greenplum Database System 267 Overview 267 Initializing Greenplum Database 268 Creating the Initialization Host File 268