Greenplum 162 Introduction to Greenplum 0 The Greenplum Master 163 Master Redundancy 163 The Segments 164 Segment Redundancy 164 Segment Failover and Recovery 165 Example Segment Host Hardware Storage 242 Elastic Block Storage (EBS) 242 Ephemeral 243 AWS Recommendations 243 Master 243 Segments 243 Google Compute Platform (GCP) 243 Virtual Machine Type 243 Compute 243 Memory 243 Compute 245 Memory 245 Network 245 Storage 246 Azure Recommendations 246 Master 246 Segments 246 Greenplum Database Best Practices 247 Greenplum Database Best Practices 0 Best Practices

## Distributed Data Structures Distributed data structures split up data across multiple segments Segments may be stored in different memory regions We need a unified concept for accessing these distributed processors into segments Segments are remotely accessible, and are located on a single rank ## Distributed Data Structures Data is typically partitioned amongst processors into segments Segments are remotely jpg) Rank n-1's Segment ## Distributed Data Structures Data structure stores a number of segments - Access data through corresponding segment - We can build iteration on top of this (although

Greenplum 231 Introduction to Greenplum 232 The Greenplum Master 233 Master Redundancy 234 The Segments 234 Segment Redundancy 235 Segment Failover and Recovery 235 Example Segment Host Hardware Stack Storage 313 Elastic Block Storage (EBS) 313 Ephemeral 314 AWS Recommendations 314 Master 314 Segments 314 Google Compute Platform (GCP) 314 Virtual Machine Type 314 Compute 314 Memory 314 Network Type 316 Compute 316 Memory 316 Network 316 Storage 317 Azure Recommendations 317 Master 317 Segments 317 Greenplum Database Best Practices 318 Best Practices Summary 319 Data Model 319 Heap vs

Greenplum 228 Introduction to Greenplum 0 The Greenplum Master 229 Master Redundancy 229 The Segments 230 Segment Redundancy 230 Segment Failover and Recovery 231 Example Segment Host Hardware Stack Storage 309 Elastic Block Storage (EBS) 309 Ephemeral 310 AWS Recommendations 310 Master 310 Segments 310 Google Compute Platform (GCP) 310 Virtual Machine Type 310 Compute 310 Memory 310 Network Type 312 Compute 312 Memory 312 Network 312 Storage 313 Azure Recommendations 313 Master 313 Segments 313 Greenplum Database Best Practices 314 Greenplum Database Best Practices 0 Best Practices

Greenplum 235 Introduction to Greenplum 0 The Greenplum Master 236 Master Redundancy 237 The Segments 237 Segment Redundancy 238 Segment Failover and Recovery 238 Example Segment Host Hardware Stack Storage 318 Elastic Block Storage (EBS) 318 Ephemeral 319 AWS Recommendations 319 Master 319 Segments 319 Google Compute Platform (GCP) 319 Virtual Machine Type 319 Compute 319 Memory 319 Network Type 321 Compute 321 Memory 321 Network 321 Storage 322 Azure Recommendations 322 Master 322 Segments 322 Greenplum Database Best Practices 323 Greenplum Database Best Practices 0 Best Practices

264 Storage 264 Elastic Block Storage (EBS) 265 Ephemeral 265 AWS Recommendations 265 Master 265 Segments 265 Google Compute Platform (GCP) 266 Virtual Machine Type 266 VMware Greenplum 6 Documentation Recommendations 269 Master 269 Segments 269 Greenplum Database Concepts 270 About the Greenplum Architecture 270 About the Greenplum Master 272 Master Redundancy 273 About the Greenplum Segments 273 Segment Redundancy 1090 Checking for Failed Segments 1091 Check for failed segments using gpstate 1091 Check for failed segments using the gp_segment_configuration table 1091 Check for failed segments by examining log files

256 Storage 256 Elastic Block Storage (EBS) 256 Ephemeral 257 AWS Recommendations 257 Master 257 Segments 257 Google Compute Platform (GCP) 258 Virtual Machine Type 258 Compute 258 Memory 258 Network 258 Machine Type 260 Compute 260 Memory 260 Network 260 Storage 260 Azure Recommendations 261 Master 261 Segments 261 Greenplum Database Concepts 262 About the Greenplum Architecture 262 About the Greenplum Master Master Redundancy 265 VMware Tanzu Greenplum 6 Documentation VMware, Inc 11 About the Greenplum Segments 265 Segment Redundancy 266 Segment Failover and Recovery 266 Example Segment Host Hardware Stack

253 Storage 253 Elastic Block Storage (EBS) 253 Ephemeral 253 AWS Recommendations 254 Master 254 Segments 254 Google Compute Platform (GCP) 254 Virtual Machine Type 254 Compute 254 Memory 254 Network 254 Recommendations 257 Master 257 Segments 257 Greenplum Database Concepts 258 About the Greenplum Architecture 258 About the Greenplum Master 260 Master Redundancy 261 About the Greenplum Segments 261 Segment Redundancy Checking for Failed Segments 1053 Check for failed segments using gpstate 1054 Check for failed segments using the gp_segment_configuration table 1054 Check for failed segments by examining log files

Storage 296 Elastic Block Storage (EBS) 296 Ephemeral 297 AWS Recommendations 297 Master 297 Segments 297 Google Compute Platform (GCP) 297 Virtual Machine Type 297 Compute 297 Memory 298 Master 300 Segments 301 Greenplum Database Concepts 302 About the Greenplum Architecture 302 About the Greenplum Master 304 Master Redundancy 305 About the Greenplum Segments 305 Segment Cluster with a Single Segment per Segment Host 387 Removing HA Service for a Cluster with a Multiple Segments per Segment Host 387 Starting the VMware Greenplum Database 388 Installing the Postmaster Service

Storage 283 Elastic Block Storage (EBS) 283 Ephemeral 283 AWS Recommendations 284 Master 284 Segments 284 Google Compute Platform (GCP) 284 Virtual Machine Type 284 Compute 284 Memory 284 Network 287 Master 287 Segments 287 Greenplum Database Concepts 288 About the Greenplum Architecture 288 About the Greenplum Master 290 Master Redundancy 291 About the Greenplum Segments 291 Segment Redundancy Performance Impact of Host Maintenance 372 High Availability Service for Greenplum Deployed With Multiple Segments Per Virtual Machine 373 Requirements 373 Adding the Greenplum Database Service 373 Managing Greenplum