Capacity 244 Estimating Storage Capacity 0 Calculating Usable Disk Capacity 244 Calculating User Data Size 245 VMware Greenplum v6.19 Documentation VMware, Inc. 9 Calculating Space Requirements for Metadata Greenplum Database Best Practices 0 Best Practices Summary 324 Best Practices Summary 0 Data Model 324 Heap vs. Append-Optimized Storage 324 Row vs. Column Oriented Storage 324 Compression 325 Data Types 337 Use Types Consistently 337 Choose Data Types that Use the Least Space 337 Storage Model 337 Heap Storage or Append-Optimized Storage 338 Row or Column Orientation 338 Compression 339

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 Greenplum Layer 298 Planning VMware vSphere with Greenplum 299 Calculating the Greenplum Database Size and ESXi Hosts 299 Determining the RAID Type 300 Determining the Number of Virtual Machines 300 391 Estimating Storage Capacity 392 Calculating Usable Disk Capacity 392 Calculating User Data Size 393 Calculating Space Requirements for Metadata and Logs 394 Configuring Your Systems 394 Deactivate

Capacity 237 Estimating Storage Capacity 0 Calculating Usable Disk Capacity 237 Calculating User Data Size 238 Calculating Space Requirements for Metadata and Logs 239 Configuring Your Systems 239 Configuring Greenplum Database Best Practices 0 Best Practices Summary 315 Best Practices Summary 0 Data Model 315 Heap vs. Append-Optimized Storage 315 Row vs. Column Oriented Storage 315 Compression 316 Data Types 328 Use Types Consistently 328 Choose Data Types that Use the Least Space 328 Storage Model 328 Heap Storage or Append-Optimized Storage 329 Row or Column Orientation 329 Compression 330

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 Greenplum Layer 267 Planning VMware vSphere with Greenplum 268 Calculating the Greenplum Database Size and ESXi Hosts 268 Determining the RAID Type 268 Determining the Number of Virtual Machines 269 329 Estimating Storage Capacity 330 Calculating Usable Disk Capacity 330 Calculating User Data Size 331 Calculating Space Requirements for Metadata and Logs 331 Configuring Your Systems 332 Disable

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 Greenplum Layer 294 Planning VMware vSphere with Greenplum 294 Calculating the Greenplum Database Size and ESXi Hosts 295 Determining the RAID Type 295 Determining the Number of Virtual Machines 296 388 Estimating Storage Capacity 389 Calculating Usable Disk Capacity 389 Calculating User Data Size 390 Calculating Space Requirements for Metadata and Logs 391 Configuring Your Systems 391 Deactivate

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 Layer 327 Planning VMware vSphere with Greenplum 327 Calculating the Greenplum Database Size and ESXi Hosts 328 Determining the RAID Type 328 Determining the Number of Virtual Machines 329 378 Estimating Storage Capacity 379 Calculating Usable Disk Capacity 379 Calculating User Data Size 380 Calculating Space Requirements for Metadata and Logs 381 Configuring Your Systems 381 Deactivate

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 Documentation VMware, Inc 13 Planning VMware vSphere with Greenplum 309 Calculating the Greenplum Database Size and ESXi Hosts 310 Determining the RAID Type 310 Determining the Number of Virtual Machines 311 404 Estimating Storage Capacity 405 Calculating Usable Disk Capacity 405 Calculating User Data Size 406 Calculating Space Requirements for Metadata and Logs 407 Configuring Your Systems 407 Deactivate

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 396 Estimating Storage Capacity 397 Calculating Usable Disk Capacity 397 Calculating User Data Size 398 Calculating Space Requirements for Metadata and Logs 399 Configuring Your Systems 400 Deactivate Distribution Key Hash Functions 564 Example Custom Hash Operator Class 564 Choosing the Table Storage Model 566 Heap Storage 566 Append-Optimized Storage 567 To create a heap table 567 Choosing Row or Column-Oriented

241 Estimating Storage Capacity 242 Calculating Usable Disk Capacity 242 Calculating User Data Size 243 Calculating Space Requirements for Metadata and Logs 244 Configuring Your Systems 245 Disable Master 317 Segments 317 Greenplum Database Best Practices 318 Best Practices Summary 319 Data Model 319 Heap vs. Append-Optimized Storage 319 Row vs. Column Oriented Storage 319 VMware Tanzu Greenplum Data Types 332 Use Types Consistently 332 Choose Data Types that Use the Least Space 332 Storage Model 332 Heap Storage or Append-Optimized Storage 333 Row or Column Orientation 333 Compression 334

Redundancy 180 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 189 Estimating Storage Capacity 190 Calculating Usable Disk Capacity 190 Calculating User Data Size 191 Calculating Space Requirements for Metadata and Logs 192 Configuring Your Systems 192 Deactivate Distribution Key Hash Functions 331 Example Custom Hash Operator Class 331 Choosing the Table Storage Model 333 Heap Storage 333 Append-Optimized Storage 334 To create a heap table 334 Choosing Row or Column-Oriented