Algorithm 238 Relaxed Rules for Specifying Table Distribution Columns 239 Resource Groups Features 239 PL/pgSQL Procedural Language Enhancements 239 Replicated Table Data 240 Concurrency Improvements in Requirements 263 Operating System 263 Storage 263 Security 264 Amazon Web Services (AWS) 264 Virtual Machine Type 264 Compute 264 Memory 264 Network 264 Storage 264 Elastic Block Storage (EBS) Ephemeral 265 AWS Recommendations 265 Master 265 Segments 265 Google Compute Platform (GCP) 266 Virtual Machine Type 266 VMware Greenplum 6 Documentation VMware, Inc 11 Compute 266 Memory 266 Network

Algorithm 228 Relaxed Rules for Specifying Table Distribution Columns 228 Resource Groups Features 229 PL/pgSQL Procedural Language Enhancements 229 Replicated Table Data 229 Concurrency Improvements in Recommendations 251 Operating System 251 Storage 252 Security 252 Amazon Web Services (AWS) 252 Virtual Machine Type 252 Compute 252 Memory 252 Network 253 Storage 253 Elastic Block Storage (EBS) Compute Platform (GCP) 254 Virtual Machine Type 254 Compute 254 Memory 254 Network 254 Storage 254 GCP Recommendations 255 Master and Segment Instances 255 Azure 255 Virtual Machine Type 256 Compute

Algorithm 231 Relaxed Rules for Specifying Table Distribution Columns 231 Resource Groups Features 232 PL/pgSQL Procedural Language Enhancements 232 Replicated Table Data 232 Concurrency Improvements in Recommendations 255 Operating System 255 Storage 255 Security 256 Amazon Web Services (AWS) 256 Virtual Machine Type 256 Compute 256 Memory 256 Network 256 Storage 256 Elastic Block Storage (EBS) Compute Platform (GCP) 258 Virtual Machine Type 258 Compute 258 Memory 258 Network 258 Storage 258 GCP Recommendations 259 Master and Segment Instances 259 Azure 259 Virtual Machine Type 260 Compute

Algorithm 257 Relaxed Rules for Specifying Table Distribution Columns 257 Resource Groups Features 258 PL/pgSQL Procedural Language Enhancements 258 Replicated Table Data 258 Concurrency Improvements in Requirements 281 Operating System 281 Storage 282 Security 282 Amazon Web Services (AWS) 282 Virtual Machine Type 282 Compute 282 Memory 282 Network 283 Storage 283 Elastic Block Storage (EBS) Compute Platform (GCP) 284 Virtual Machine Type 284 Compute 284 Memory 284 Network 284 Storage 284 GCP Recommendations 285 Master and Segment Instances 285 Azure 285 Virtual Machine Type 286 Compute

Algorithm 207 Relaxed Rules for Specifying Table Distribution Columns 207 Resource Groups Features 207 PL/pgSQL Procedural Language Enhancements 208 Replicated Table Data 208 Concurrency Improvements in Recommendations 228 Operating System 228 Storage 228 Security 229 Amazon Web Services (AWS) 229 Virtual Machine Type 229 Compute 229 Memory 229 Network 229 Storage 229 Elastic Block Storage (EBS) Compute Platform (GCP) 230 Virtual Machine Type 230 Compute 231 Memory 231 Network 231 Storage 231 GCP Recommendations 231 Master and Segment Instances 232 Azure 232 Virtual Machine Type 232 Compute

Algorithm 271 Relaxed Rules for Specifying Table Distribution Columns 271 Resource Groups Features 271 PL/pgSQL Procedural Language Enhancements 272 Replicated Table Data 272 VMware Greenplum 6 Documentation Public Cloud Requirements 295 Operating System 295 Storage 295 Amazon Web Services (AWS) 295 Virtual Machine Type 295 Compute 296 Memory 296 Network 296 Storage 296 Elastic Block Storage (EBS) Compute Platform (GCP) 297 Virtual Machine Type 297 Compute 297 Memory 298 Network 298 Storage 298 GCP Recommendations 298 Master and Segment Instances 299 Azure 299 Virtual Machine Type 299 Compute

Public Cloud Requirements 148 Operating System 148 Storage 148 Amazon Web Services (AWS) 148 Virtual Machine Type 148 Compute 149 Memory 149 Network 149 Storage 149 Elastic Block Storage (EBS) Platform (GCP) 150 Virtual Machine Type 150 Compute 150 Memory 150 Network 150 Storage 151 GCP Recommendations 151 Coordinator and Segment Instances 151 Azure 152 Virtual Machine Type 152 Compute About Database Statistics in Greenplum Database 180 System Statistics 181 Table Size 181 The pg_statistic System Table and pg_stats View 181 Sampling 185 Updating Statistics 185 Analyzing Partitioned

Algorithm 210 Relaxed Rules for Specifying Table Distribution Columns 210 Resource Groups Features 211 PL/pgSQL Procedural Language Enhancements 211 Replicated Table Data 212 Concurrency Improvements in Recommendations 308 Operating System 308 Storage 308 Security 308 Amazon Web Services (AWS) 308 Virtual Machine Type 308 Compute 309 Memory 309 Network 309 Storage 309 Elastic Block Storage (EBS) Ephemeral 310 AWS Recommendations 310 Master 310 Segments 310 Google Compute Platform (GCP) 310 Virtual Machine Type 310 Compute 310 Memory 310 Network 311 VMware Greenplum v6.18 Documentation VMware

Specifying Table Distribution Columns 218 VMware Greenplum v6.19 Documentation VMware, Inc. 8 Resource Groups Features 219 PL/pgSQL Procedural Language Enhancements 219 Replicated Table Data 220 Concurrency Recommendations 317 Operating System 317 Storage 317 Security 317 Amazon Web Services (AWS) 317 Virtual Machine Type 317 Compute 318 Memory 318 Network 318 Storage 318 Elastic Block Storage (EBS) Compute Platform (GCP) 319 Virtual Machine Type 319 Compute 319 Memory 319 Network 320 Storage 320 GCP Recommendations 320 Master and Segment Instances 320 Azure 321 Virtual Machine Type 321 VMware

Recommendations 241 Operating System 241 Storage 241 Security 241 Amazon Web Services (AWS) 241 Virtual Machine Type 241 Compute 242 VMware Greenplum v6.17 Documentation VMware, Inc. 9 Memory 242 Compute Platform (GCP) 243 Virtual Machine Type 243 Compute 243 Memory 243 Network 244 Storage 244 GCP Recommendations 244 Master and Segment Instances 244 Azure 245 Virtual Machine Type 245 Compute Aliases for Function Parameters 390 Example: Using the Data Type of a Table Column 390 Example: Composite Type Based on a Table Row 391 Example: Using a Variable Number of Arguments 392 Example: Using