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

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 Software 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

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 Machine 351 Creating the Base Virtual Machine 351 Preparing the Virtual Machine 352 Performing System Configuration 352 Installing the Greenplum Database Software 360 Validating the Base Virtual Machine

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 Machine 341 Creating the Base Virtual Machine 341 Preparing the Virtual Machine 342 Performing System Configuration 342 Installing the Greenplum Database Software 350 Validating the Base Virtual Machine

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 Machine 337 Creating the Base Virtual Machine 337 Preparing the Virtual Machine 338 Performing System Configuration 338 Installing the Greenplum Database Software 346 Validating the Base Virtual Machine

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 Template 304 Creating the Virtual Machine Template 305 Preparing the Virtual Machine 305 Performing System Configuration 306 Installing the Greenplum Database Software 312 Creating the Greenplum Template

134 Additional Supplied Modules and Extensions 134 SQL Commands 135 Database Maintenance 136 System Functions, Catalog Tables and Views 137 Greenplum Query Optimizer (GPORCA) 138 Append-Optimized Deprecated Features 140 Known Issues and Limitations 140 Platform Requirements 141 Operating System Requirements 141 Software Dependencies 141 Java 143 Python 143 VMware Greenplum Tools and Extensions Boost (VMware Greenplum) 147 Hadoop Distributions 147 Public Cloud Requirements 148 Operating System 148 Storage 148 Amazon Web Services (AWS) 148 Virtual Machine Type 148 Compute 149 Memory 149

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

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

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