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 About the Greenplum Interconnect 309 Interconnect Redundancy 309 Network Interface Configuration 309 Switch Configuration 310 About ETL Hosts for Data Loading 311 About VMware Greenplum Performance Monitoring

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 About the Greenplum Interconnect 295 Interconnect Redundancy 295 Network Interface Configuration 295 Switch Configuration 296 About ETL Hosts for Data Loading 297 About VMware Greenplum Performance Monitoring 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

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 About the Greenplum Interconnect 277 Interconnect Redundancy 277 Network Interface Configuration 277 Switch Configuration 278 About ETL Hosts for Data Loading 279 About VMware Greenplum Performance Monitoring 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

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 About the Greenplum Interconnect 269 Interconnect Redundancy 269 Network Interface Configuration 269 Switch Configuration 270 About ETL Hosts for Data Loading 271 About Tanzu Greenplum Performance Monitoring 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

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 About the Greenplum Interconnect 265 Interconnect Redundancy 265 Network Interface Configuration 265 Switch Configuration 266 About ETL Hosts for Data Loading 267 About Tanzu Greenplum Performance Monitoring 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

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 About the Greenplum Interconnect 240 Interconnect Redundancy 240 Network Interface Configuration 240 Switch Configuration 241 About ETL Hosts for Data Loading 242 About Tanzu Greenplum Performance Monitoring 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

Layout 239 The Interconnect 240 Interconnect Redundancy 240 Network Interface Configuration 240 Switch Configuration 241 ETL Hosts for Data Loading 242 Tanzu Greenplum Performance Monitoring 243 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

18 Documentation VMware, Inc. 8 Interconnect Redundancy 233 Network Interface Configuration 233 Switch Configuration 234 ETL Hosts for Data Loading 235 Tanzu Greenplum Performance Monitoring 236 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

Layout 237 The Interconnect 238 Interconnect Redundancy 238 Network Interface Configuration 238 Switch Configuration 239 ETL Hosts for Data Loading 240 Tanzu Greenplum Performance Monitoring 241 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

Layout 166 The Interconnect 166 Interconnect Redundancy 167 Network Interface Configuration 167 Switch Configuration 168 ETL Hosts for Data Loading 169 Greenplum Performance Monitoring 170 Estimating 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