........................................................................................48 5.4. System Columns......................................................................................... ...................................................................................59 5.7.5. The System Catalog Schema ..............................................................................59 5 .........................201 9.19. System Information Functions ....................................................................................202 9.20. System Administration Functions ..........

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

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

........................................................................................63 5.4. System Columns......................................................................................... ...................................................................................71 5.7.5. The System Catalog Schema ..............................................................................72 5 .........................287 9.25. System Information Functions ....................................................................................290 9.26. System Administration Functions ..........

........................................................................................62 5.4. System Columns......................................................................................... ...................................................................................71 5.7.5. The System Catalog Schema ..............................................................................71 5 .........................267 9.23. System Information Functions ....................................................................................269 9.24. System Administration Functions ..........

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

Constraints ..................................................................................57 5.4. System Columns......................................................................................... Privileges................................................................................65 5.7.5. The System Catalog Schema .......................................................................66 5.7.6. Usage .............................270 9.25. System Information Functions .............................................................................273 9.26. System Administration Functions .............

Constraints ..................................................................................57 5.4. System Columns......................................................................................... Privileges................................................................................65 5.7.5. The System Catalog Schema .......................................................................65 5.7.6. Usage .............................249 9.23. System Information Functions .............................................................................251 9.24. System Administration Functions .............